Update rate.

• senthilj

  SSC-Addicted

  Points: 442

  More actions

  July 8, 2002 at 1:23 pm

  #79398

  Why is the update rate dependent on the number of columns I update. For example updating all the columns in a table with 100 columns is slower than updating just 10 or 20 columns. Irrespective of the number of columns I update, SQL server has to read and write the entire row right.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  July 8, 2002 at 1:41 pm

  #432209

  One would think so. It may depend on what you are changing. I'd guess that 100 int cols is similar to 10 int cols. For varchar, you may introduce page splits, which can substantially slow the item.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones