[vox-tech] Call for SQL help

[Harold Lee]

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 <brian at brie.com> 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
> vox-tech at lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.lugod.org/pipermail/vox-tech/attachments/20090422/c0d1022d/attachment.htm