Looks like MySQL 5.4 fixes that performance issue: http://dev.mysql.com/tech-resources/articles/mysql-54.html
On Sat, Apr 18, 2009 at 6:01 PM, Brian Lavender <[email protected]> wrote: > 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 >
_______________________________________________ vox-tech mailing list [email protected] http://lists.lugod.org/mailman/listinfo/vox-tech
