[mythtv-users] Slow MySQL query after delete

Mike Perkins mikep at randomtraveller.org.uk
Sat Sep 8 11:54:15 UTC 2007

Johan Venter wrote:
> 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* :)
Who was it said, "Just because you *can*, doesn't mean you *should*"? There are 
some things that are better off in queries, and some that are better left as 
c++/Perl/whatever. Makes the job of the guy who comes after you that much 
easier, amongst other things.

Mike Perkins

More information about the mythtv-users mailing list