MySQL Forums
Forum List  »  Performance

Re: What is better? A large query? or too many short ones?
Posted by: Daniel Nichter
Date: October 31, 2005 08:40PM

Although many factors affect performance, without knowing further details of your db design, the data, queries, etc., I would say 1 large query would be faster because MySQL will only have to parse/plan/execute one query. Multiple small queries incur all the additional work of parse/plan/execute and index updates.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is better? A large query? or too many short ones?
1242
October 31, 2005 08:40PM


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.