[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

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 query