Re: A MySQL Question
| From: | Nathan Rixham | Date: | Tue, 09 Dec 2008 00:16:09 +0000 |
| Subject: | Re: A MySQL Question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284334@lists.php.net to get a copy of this message | ||
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +0000, ceo@l-i-e.com wrote:any chance of writing the implementation of that bigbang() function? give you a pound!Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. IN has to process them all and find them all.Don't forget the special case use as well: IF NOT EXISTSuniverseTHEN bigbang() Ash www.ashleysheridan.co.uk