MySQL Forums
Forum List  »  Knowledge Base

Complex query vs. a number of simple queries
Posted by: Aman Rawal
Date: June 05, 2009 02:40AM

Hi,

I have a fairly complex sql query which would need to get data from 5 or 6 tables. I was wondering to split these queries into multiple simple one. However a lot of queries (around 100) would be made then.

My question now... How will this impact on performance. Will it be quicker with one complex query or is this negligible since this simple queries are very quick?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Complex query vs. a number of simple queries
4890
June 05, 2009 02:40AM


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.