MySQL Forums
Forum List  »  Newbie

update best practices
Posted by: morgan
Date: March 28, 2005 10:44AM

When updating a record, is it best to:

a) filter out the fields that have not been changed (in this case by using php) and just include the fields that have been changed

b) simply update the entire row, regardless of whether any changes have been made to a particular field (i.e. overwrite the same values already in the database).

I can see pros and cons for both sides. I was wondering if there is an accepted "best practice" for updates??

Thanks in advance,

Morgan

Options: ReplyQuote


Subject
Written By
Posted
update best practices
March 28, 2005 10:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.