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

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

2004-11-08 Thread raditha dissanayake
Greg Donald wrote: On Mon, 08 Nov 2004 10:40:30 +0600, raditha dissanayake <[EMAIL PROTECTED]> wrote: You know you're a geek when you know which list deals with which top and when you know that subselects in mysql is not much faster than the nested loop you have been using. Can you point me