解析XML并写入大型CSV文件

Question

如何有效地解析大型XML文件（4GB）并在CSV中写入行？ 现在，我正在使用lxml和csv.

xmltree = etree.parse("my.xml")
xmlroot = xmltree.getroot()
with open(file_name, 'w') as file:
    writer = csv.writer(file, delimiter=",")
    for tag in xmlroot.findall('*'):
        csv_row = []
        for attribute in attribute_list:
            attribute_value = None
            if tag.findall(my_list):
                attribute_value = tag.find(attribute).text
                csv_row.append(attribute_value)
        writer.writerow(csv_row)