I was asking a question about Merging geodatabase previously, (link: Merge from arcpy.ListTables() producing duplicate rows?) and although the script worked, it took more than 9 hours to run when merging >3000 tables with 1 rows in each table. I was wondering whether instead of merging the tables it would be faster to write the contents of each geodatabase table into a csv file and keep appending tables to it. If so, how to do it?? I now need to merge tables of different geodatabase (it has 39 fields and varying number of rows) and I have a feeling that if I use the script from my previous question it will take even longer than 9 hours.
Basically, how to iterate through 3000 tables and write the attribute tables of each to the same csv and keep appending to it?
Here's the screenshot of the geodatabase tables I talked about above: