AnsweredAssumed Answered

Performance for Append vs Insert Cursor

Question asked by alantoms on Aug 9, 2013
Latest reply on Aug 22, 2013 by rfairhur24
Ok I have a feature class (260k records) and 3 tables.  I need to get specific information (about 20 fields) from each into a new feature class.  I have several different ways to do this and I???m curious if anyone has done any performance testing and  knows which of my options would be ???best???.

Option 1
I could create several joins and append the data into the new feature class, with some additional field calculations for cleanup.

Option 2
Create a python script that would loop through each record, search cursor the other tables for data, then insert cursor into the new feature class.


Thank you
Alan

Outcomes