performance degradation after several inserts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

We have a VB6 app that uses an MSDE SP3 database. We use a process with
transactions to add data to the database. As several similar packets of data
are added we've noticed a degradation in the speed of loading the
information. We've also noticed that if at the end of the insert of several
packets of data we get a 30 second upload time per packet, then shut down
MSDE, start it up again and then insert in an almost identical packet of
data, it will run twice to 3 times faster.

We tried turning autoshrink and auclose off but that didn't seem to help.

Thanks,

Terry
.

Relevant Pages