MySQL Forums
Forum List  »  Performance

Re: What is better? A large query? or too many short ones?
Posted by: KimSeong Loh
Date: November 01, 2005 07:57PM

MySQL needs to read/write the whole row no matter how many fields you update in the same row.

If you do 10 updates on different fields of the same row, it will need to write 10 times.
So, do it once and let MySQL do the disk write once and for all.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is better? A large query? or too many short ones?
1165
November 01, 2005 07:57PM


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.