I have a sql server spatial table of around 9M points which for backup purposes I'm scripting to create a copy in SDE. I was initially truncating the SDE table and using append to re-populate which took around 3 hours. To improve performance I read about using the da.Insert and search cursors and having implemented that do have it working, but it took around 8 hours. I'm fairly new to using these cursors, so I maybe don't have this configured correctly, so any advise would be appreciated. Sample of the code is below.
sql_tb = "INPUT_SQL_TB" sde_fc = "OUTPUT_SDE_FC" with arcpy.da.InsertCursor(sde_fc,['FIELD1','FIELD2','SHAPE@XY']) as icur: with arcpy.da.SearchCursor(sql_tb,['FIELD1','FIELD2','SHAPE@XY']) as scur: for srow in scur: icur.insertRow(srow) del icur,scur
Thanks in advance for any feedback, Mike.