adam84 Posted July 9, 2008 Share Posted July 9, 2008 I am currently writing an sql query. As of now, I am crossing three different tables and with doing this the sql statement is starting to become quite large. I am just wondering if it would be quicker for me and for the execution time if I were to split up the query into two different queries or is it always best to put everything I need into one big query and let the system do what it needs to do. Thanks Quote Link to comment Share on other sites More sharing options...
olie122333 Posted July 9, 2008 Share Posted July 9, 2008 I haven't tested this, but i think it may be quicker to do it in multiple querys. (Aulthough this would use more server resources.) Up to you really. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 9, 2008 Share Posted July 9, 2008 Post the EXPLAIN for your SELECT statement and I'll tell you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.