Performance Issue: Updating a Table

Results 1 to 2 of 2

Thread: Performance Issue: Updating a Table

  1. #1
    TuT Guest

    Default Performance Issue: Updating a Table

    IF I have a form with sixteen text boxes, which can be changed each time the form is submitted, which is better<BR><BR>just overwriting whatever in the table with whatever is on the ofrm<BR><BR>or check the table against the form each time it is submitted and then updating fields only if and where the two don&#039;t match?<BR><BR>Will one be less work than the other?

  2. #2
    Join Date
    Dec 1969

    Default RE: Performance Issue: Updating a Table

    Only updating what&#039;s changed: Easier on the DB, more work for you.<BR><BR>Updating the whole record: Easier for you, a little more work for the DB. How busy is the site? Will that extra little bit of time updating the whole record cause a problem? I would guess no, but I could be mistaken.

Posting Permissions

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