AnsweredAssumed Answered

Slow Table Merge: Python

Question asked by bem08c on Sep 13, 2016
Latest reply on Sep 19, 2016 by curtvprice

Hi all, 

 

I'm merging together 4416 tables all within a single geodatabase, each table has two records in it. I've run this simple python script twice now, once it made it to table 343 after 7 hours, the second time 791 after 16 hours. Both times the script averaged 49 merged tables per hour which means this script would take a total of 90 hrs to run. Is there any other tool i can run that would make this run faster?

 

Thanks

import arcpy
arcpy.env.workspace = "C:\\DeleteMe\\tomerge\\tables.gdb"
tblList = arcpy.ListTables()
arcpy.Merge_management(tblList,"Merged")

Outcomes