[mythtv-users] Slow MySQL query after delete
Jay R. Ashworth
jra at baylink.com
Sat Sep 8 01:03:25 UTC 2007
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
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
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