SQL Server Performance

Update performance

Discussion in 'Getting Started' started by veejay, Aug 14, 2007.

  1. veejay New Member

    Heres the situation:
    I have an old image of a record in my table, for which I now have an updated image. I need to update the old image with the new one.Only catch is, I dont really know which fields from the old image have been changed. In order to find out what fields have changed, I will have to compare the two images, which I would like to avoid. It does not matter to me, if I update all the fields blindly, without comparing. But in this case I would be updating more fields than might be required.
    My question is:
    Would an update with more fields be more time consuming than one with lesser fields ?
    --Learning forever
  2. satya Moderator

    Welcome to the forum!
    You have to more clear about image & fields here, are you trying to update any TEXT/IMAGE data field. If not what are those columns that needs update with the new data.
  3. veejay New Member

    Thanks for the quick response.
    The fields I would be updating would be strictly text fields. No images. A mix of NUMBER and VARCHARS... Its actually a quote ( used in exchanges). The quote has now been modified. Lets say the price, quantity,...etc....
    The modified quote could have variable number of updated fields...
    --Learning forever

Share This Page