I am trying to update 3 tables in SDE. In order to do so, I'm finding I need to use ArcSDEQuerier to delete all of the records in the tables before updating the tables. The data is updated during the day in a Microsoft Access Database, I then need to run the routine every night to update the SDE tables (the tables have 16,000+, 25,000, and 23,000 records). The problem is that the ArcSDEQuerier is taking an extremily long time. My initial estimate looks as if it will take an entire day to run just to complete the delete. The actual delete only takes a couple of minutes. It then has to run every record through the <Query> result. I'm not sure what that is even doing. I can't find a good explination for it in the help or anywhere online. That step takes ~1-2 seconds per record, which adds up when you have ~64,000 records. Is there anyway to stop this step? Or to just simply delete the data from the tables? I have tried using both an Esri ArcSDE reader as well as an Esri Geodatabase (ArcSDE Geodb) reader. I get the same result regardless.
Any suggestions would be much appreciated.
