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


Leave a comment

Your email address will not be published.