Hamdella 3alla elsalama Mr.Alaa ;) please call me if u can or send me ur phone number here
Best Regards, On 4/3/07, Ala'a Ibrahim <[EMAIL PROTECTED]> wrote: > > 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/ > > > -- Malik I. Shishtawi ---------------------------------------- CEO & Co-Founder MyTekPlus | Training & IT Solutions [EMAIL PROTECTED] Mobile: + 962 -7 99 43 88 77 --~--~---------~--~----~------------~-------~--~----~ 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/ -~----------~----~----~----~------~----~------~--~---
