Export (0) Print
Expand All

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft