On Fri, Apr 17, 2009 at 11:20:01AM -0700, Bill Kendrick wrote:
>
> On Thu, Apr 16, 2009 at 06:06:21PM -0700, Bryan Richter wrote:
> > 1. Definetely break out subqueries. A possible starting point would be
> > creating a temp table of interesting categories. Temp tables are
> > indispensible.
> >
>
> Ah, my predecessor popped up and mentioned this discovery. Instead of
> the subselect ("AND bc.categoryid IN ( SELECT ... )"), doing the following
> 'EXISTS' test does the same thing.
>
> It now takes under 1 second, rather than 90 seconds. A speed improvement
> of over 100x. Yay :)
>
> bill.beers_owed_to_people++;
I could go for some beer. Are you buying? :)
--
Brian Lavender
http://www.brie.com/brian/
_______________________________________________
vox-tech mailing list
[email protected]
http://lists.lugod.org/mailman/listinfo/vox-tech
