I have data in a file geodatabase feature class that I am appending to a feature class in an enterprise geodatabase.
This is the code:
(assume variables are assigned and existing. Arcpy and Time are imported)
start_time = time.clock()
arcpy.Append_management(local_fc_path, sde_fc_path, "NO_TEST")
elapsed_time = (time.clock() - start_time)
print "Append Took {}".format(elapsed_time)
This takes 1105.675 seconds (over 18 minutes) for 138 features. In practice, no matter how many rows are in the source table, it takes about this much time.
Running the append in the Python interpreter in ArcMap 10.2.1 for the same 138 features takes .94 seconds
When doing the same thing in ArcMap 10.2.1 using the Append tool from the Data Management toolbox, with the same parameters and same 138 features, it takes 1.03 seconds.
Is there any explanation for this?
