Re: [PHP] You know you're a geek when...

2004-11-08 Thread Greg Donald
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 to some benchmarks that

[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

[PHP] You know you're a geek when...

2004-11-07 Thread Murray @ PlanetThoughtful
.You upgrade MySQL from 4.0.x to 4.1.x and you get excited because now you can include subselects in your pages. Much warmth, Murray http://www.planetthoughtful.org Building a thoughtful planet, One quirky comment at a time. -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] You know you're a geek when...

2004-11-07 Thread raditha dissanayake
Murray @ PlanetThoughtful wrote: .You upgrade MySQL from 4.0.x to 4.1.x and you get excited because now you can include subselects in your pages. 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

Re: [PHP] You know you're a geek when...

2004-11-07 Thread Ryan King
On Sunday, November 07, 2004, at 10:38PM, raditha dissanayake [EMAIL PROTECTED] wrote: Murray @ PlanetThoughtful wrote: .You upgrade MySQL from 4.0.x to 4.1.x and you get excited because now you can include subselects in your pages. You know you're a geek when you know which list deals

Re: [PHP] You know you're a geek when...

2004-11-07 Thread raditha dissanayake
Ryan King wrote: On Sunday, November 07, 2004, at 10:38PM, raditha dissanayake [EMAIL PROTECTED] wrote: Murray @ PlanetThoughtful wrote: .You upgrade MySQL from 4.0.x to 4.1.x and you get excited because now you can include subselects in your pages. You know you're a geek when you