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 Link to comment https://forums.phpfreaks.com/topic/113957-question-about-a-query/ 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. Link to comment https://forums.phpfreaks.com/topic/113957-question-about-a-query/#findComment-585689 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. Link to comment https://forums.phpfreaks.com/topic/113957-question-about-a-query/#findComment-585745 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.