Results 1 to 2 of 2

Thread: Simple opinion

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 1999
    Location
    Reynosa, Mexico
    Posts
    274
    In a WAN environment, how many time can I save if I update just one field and if I update 15 fields?
    Ulises Vázquez
    [size=1.7]Oracle DBA Certified Professioanl
    Visual Basic 6 Developer
    Crystal Reports Designer
    [/size]

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Depends.

    In SQL server, for example, a varchar field triggers a delete/insert update under certain cirumstances (if the varchar value is larger than it was before or if the varchar is part of the primary key). This kind of update takes longer than the usual "update in place" update.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width