Sub selects vs nested loop was:Re: [PHP] You know you're a geek when...
| From: | raditha dissanayake | Date: | Mon, 08 Nov 2004 15:57:41 +0000 |
| Subject: | Sub selects vs nested loop was:Re: [PHP] You know you're a geek when... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-201537@lists.php.net to get a copy of this message | ||
Greg Donald wrote:
On Mon, 08 Nov 2004 10:40:30 +0600, raditha dissanayake <jabber@raditha.com> wrote:-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar.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 support this claim? Thanks. 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 properly or that I may not have had the correct indexes, but since I have been doing this for quite a few years i like to think i got the query right. (feel free to deflate my ego :-) )