Do you have indexes on your tables? If you have really large amounts of data, and it sounds like you do, updates to the tables will get slower and slower since the index files have to updated. When the users import data into our system, we delete the index files if they are importing a large amount of data, then import the data and re-create the indexes. Even though it takes a while to reindex at the end, it can be much quicker than just importing with the indexes in place.

Also, how often is your wait window being updated? Updating this will slow the process down some, especially if you're updating it very frequently.

>I have a form that is reading data from several text files and inserting it into tables. It has been running for 26 hours so far. I have a wait window that is showing me a counter. I have noticed that it is getting slower and slower the longer it runs.
>
>Is there anything I can do to prevent it from slowing down?
>
>Thanks
>
>Pat Murphy