URGENT: Bad performance
Posted on 2001-07-01
When executing a batch on a customer db, inserting and updating about 50.000 records, it takes forever to complete.
This I think, because after each record the indexes are updated. Is there a way to prevent an index from updating untill the batch completes?
Are there any other solutions to get a better performance?