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++;
-bill!
_______________________________________________
vox-tech mailing list
[email protected]
http://lists.lugod.org/mailman/listinfo/vox-tech
