Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Update Hints

SQL Server 2000

Update Hints

Because the repository engine sends updates to the database in a batch at transaction commit time, a single long transaction is preferable to many small ones. This is true for any combination of inserts, deletes, and updates. For moderate-sized objects, you should be able to update 25,000 objects within one transaction without hitting cache size limitations.

Use the automatic delete propagation feature of relationships wherever possible. This allows the engine to delete objects in a batch.

See Also

Propagating Deletes

Optimizing Repository Performance

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.