ubanide

Poor performance  Adding a field in SDE

Discussion created by ubanide on Feb 8, 2012
Latest reply on Feb 9, 2012 by ubanide
I have written a python script to add some fields to an existing table.

Arcmap10
SDE 10
oracle 11G

the add field looks like

arcpy.AddField_management(targetFC, fieldname, fieldtype, "", "", "", "", "NULLABLE", "NON_REQUIRED", "")

It works but it takes about two min for each add. This seems really slow to me given Oracle is on a scream'n box that has 8 processors and 32GB of RAM.  The network is running a Gig-E.  I tested it out on a File GDB first and it add each field in about a second.  What gives?  Oracle should be able to do this in < 1sec.


Thanks

Outcomes