We are running ArcGIS Server 9.3.1 with Oracle 11g. I have a number of featureclasses in the SDE database that needs to be replaced once a week. Each week I get CSV files from our mainframe that need to be loaded to the Featureclasses in SDE replacing the features that are already there. I have written a python script to handle all the processing involved, but it takes 19 hours to run. It appears that the srcipt is having trouble with the DeleteFeatures_Management tool and takes a very long time to run. It hangs on the largest Featuredataset which contains 210230 features. The rest of the script takes only 20 minutes to run. This data is being used in a web map to allow the field crews access to the data. Because of this, I have versioned the data so I would not have to disable the service for the web map.
Is there a more efficient way to delete all the features in the featureclasses?
The only thing I can think of is to make sure your versions are reconciled, posted, deleted and db compressed.
Are you able to use 10?
Could you provide the python script you are doing to update SDE weekly? I have been trying to do this and keep running into issues with versions and/or locking (I have an ArcGIS Server service hitting the feature class).