Well actually it has a lot of answers, as this formula has a lot of inputs,
like how tuned is your database, how is your load on the database, how often
you use caching in your application.
as Ammar said you just have to benchmark.
On 4/3/07, Ammar Ibrahim <[EMAIL PROTECTED]> wrote:
>
> The replies surprised me, some were misleading. The best way is to
> benchmark instead of guessing; write both queries run them a gazillion times
> and see the numbers.
> Please share your findings with us.
>
> - Ammar
>
> On 3/28/07, 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
> >
> >
>
> >
>
--
Ala'a A. Ibrahim
http://guru.alaa-ibrahim.com/
--~--~---------~--~----~------------~-------~--~----~
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/
-~----------~----~----~----~------~----~------~--~---
