Re: [PHP] Sub selects vs nested loop

2004-11-09 Thread electroteque
Hi guys and girls, while we are on this topic, has anyone got a good senario of a sub select query which can remove the nested loops ? I have been wanting to get rid of nested loops for a good while and now Mysql 4.1 is out I would like to start using it. So the usual scenario for nested loops

Re: [PHP] Sub selects vs nested loop was:Re: [PHP] You know you're a geek when...

2004-11-08 Thread Greg Donald
On Mon, 08 Nov 2004 21:57:41 +0600, raditha dissanayake <[EMAIL PROTECTED]> wrote: > Sorry no benchmarks, i am talking from personal experience where I > converted some code from a php nested loop to mysql. I was rather > surprised by the results. I will concede that I may not have optimized > the