Python scripts that update SDE Layers with NWS local storm report data

Discussion created by ctalleygreenville on Aug 23, 2012
Latest reply on Mar 3, 2015 by gtuchristina
Hello all,

Not sure if this is an SDE question or a python question, but here goes...

I have been using some python code since late 2009 that was written by John Karagiannis when he was with ESRI.  I use the set of scripts that updates a SDE feature class with downloaded National Weather Service's local storm report data.  It is run every 30 minutes and is utilized in our FLEX Situational Awareness application.  The number of records is NOT large - usually under 100 unless there is a lot of bad weather.

Up until our ArcGIS/ArcSDE upgrade to 10 in April, the script would take 10-20 seconds to run.  After the upgrade to 10, I altered the python code to use arcpy instead of gp.  All seemed to work okay.  But I didn't realize that slowly since April, the time it takes for the script to run reached 18 minutes (for 93 records).  Plus I realized that it takes a LONG time to access the feature class in Catalog.  Plus it is taking a long time to display in Flex.

I had another copy of the feature class in a TEST database (that would still connect quickly in Catalog) and I tried running the script against it.  It still took a lot longer than 10 seconds.  Plus, when I set it to run every 30 minutes, the time to process started creeping up higher and higher.  After a while, it was again taking longer to connect to the layer in Catalog.

Any idea what is happening and why the switch to 10 changed it all??

More background:  This script(s) access a url at Iowa State, downloads a shapefile and saves it locally.  Then, it accesses a SDE feature class, deletes all the existing records and appends the new records from the shapefile.  This is the portion of the module that does the data load - this is where I see the slow down.

(dst contains the string to the SDE feature class that is unversioned)

def load_data(src, dst):
    if arcpy.Exists(src):
        if arcpy.Exists(dst):
                #delete the features from the sde feature class
                print "before delete"
                print "after delete"
                #append the new features from the shapefile to the sde feature class
                #print "here"
                arcpy.Append_management(src, dst, 'NO_TEST', '')
                print "after Append"
                write_to_log('  Processed ' + src + ' to ' + dst)
                write_to_log('  Error Processing ' + src + ' to ' + dst)
                write_to_log('  ' + arcpy.GetMessages(2))
            write_to_log('  SDE feature class ' + dst + ' does not exist')
        write_to_log('  Shape file ' + src + ' does not exist')

Thanks for any help you can provide.  Maybe someone else is using these same scripts out there since they weren't created just for us!