SQL Server XML Performance Tips

Here are some ways you can help to maximize the performance of Updategrams:

  • If you use the sql:key-fields annotation, be sure you select a primary key for each table. If you don’t, all columns in the before element are included in the WHERE clause, and can cause the search to take much longer than necessary.
  • If you are going to update or delete data a record, and you don’t care what the before value is, you can help boost performance of Updategrams by not including all the columns included in the before element in the WHERE clause.
  • If an Updategram is used to make unrelated updates, the updates should be split into separate synch blocks. This reduces the transaction size, and helps to boost performance.

[2000, 2005, 2008] Updated 1-29-2009

Pages: 1 2


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |