[mythtv-users] Slow MySQL query after delete

[Jay R. Ashworth]

On Sat, Sep 08, 2007 at 10:53:04AM +1000, Johan Venter wrote:
> > Yeah, I know, right?  :-)  I didn't know you *could* put CASEs in
> > querys; is that a MySQL thing?
> 
> Nope, can do it in most compliant databases, SQL Server and Postgres 
> included.

Be damned.  It was oh, maybe 92 or 3 the last time I got heavily into
SQL; must be newer than that.

> I don't know what all the fuss is about, I've written and maintained 
> queries *much* larger than that before - and I'm not exaggerating nor 
> trying to boast.
> 
> I used to work under a developer who decided it would be a grand idea to 
> have *all* of the business logic for the application we were working on 
> enforced in the SQL queries/stored procedures. I have debugged queries 
> that span *pages* :)

Our condolences.  :-0

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