Use PHP to make them combine, In my opinion huge queries can put load on MySQL server.
On Mar 28, 5:55 pm, "Al-Faisal El-Dajani" <[EMAIL PROTECTED]> wrote: > Hello guys, > > I was just trying to write a complex SQL statement and it came to my mind, > what would be more effecient? one huge monolithic statement with outer joins > and subqueries and all? or break it down to 3 or 4 consecutive SQL > statements and use PHP to glue them together? > I'm using MySQL with InnoDB transaction manager, the mysql api for php (not > mysqli, i don't know if this matters), and almost all fields that i need for > join are indexed. Is it better to do one statement that joins 8 tables and > has 2 levels of subqueries, or break it down to 4 seperate statements and > join them with php? > > -- > Al-Faisal El-Dajani > Phone: +962-7-77 799 781 > P.O Box: 140056 > 11814 Amman, Jordan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Jordan PHP Users Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/JoPHP http://Jolug.org/ -~----------~----~----~----~------~----~------~--~---
