How does arcpy communicate with SDE?

Discussion created by ubanide on Feb 14, 2012
Latest reply on Feb 14, 2012 by jskinner-esristaff
I have written a script in python and added it to a toolbox in ArcMap.  I pass the feature layer that I am working on as a parameter to the script.  It works but it seems to be very slow.  When I run the same script on a file GDB it take maybe ten second to complete.  When I run it on the same data only this time the feature class is on SDE it take 20 min. to complete.  What gives?  Shouldn't  working on SDE be as fast if not faster than a file base Database?  How do I find out what is happening?

I am running arcmap 10 latest release but not the latest SP.  SDE is on 10 running on top of oracle 11 on a windows based server.