[mythtv-users] Slow MySQL query after delete
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.
More information about the mythtv-users