[mythtv-users] Slow MySQL query after delete

Jay R. Ashworth jra at baylink.com
Fri Sep 7 14:49:46 UTC 2007


On Fri, Sep 07, 2007 at 03:24:39PM +0100, Mike Perkins wrote:
> Is it not possible, within scheduler.cpp, to break down the BUSQ in
> such a way that it is more comprehensible by the devs and easier for
> MySQL to deal with? I have done some refactoring of similar beasts in
> the past (~5 years) and know it can make a hell of a difference to
> maintainability if nothing else.
>
> Just saw the prettyprinted BUSQ. OMFG. (picks jaw off floor)

Yeah, I know, right?  :-)  I didn't know you *could* put CASEs in
querys; is that a MySQL thing?

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274


More information about the mythtv-users mailing list