Re: An SQL query lasts 60 seconds...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:954767653.8388.2.pluto.d4ee154e_at_news.demon.nl...
>
> Sorry to be a bit blunt, to me it looks like ridiculous someone is
> complaining about a query lasting 60 seconds. In one of my previous jobs
 90
> mins was normal. OK, I didn't write it, and we got user revolt, I admit
> that, but the cause was all grouping and sorting was executed on the
 client.
> In that case you can tune a network whatever you want, but you need to get
> rid of sorting at the client side.
>

Thankfully someone said this ;) I get so tired of hearing people bitch about query processing times. Yes...sometimes queries are written poorly and can really be optimized but to expect every query to come back in less than a minute every time is just stupid. Not blaming the guy who posted here. However developers and others should be trying to get across to users that depending on the database not everything is going to be fast all the time.

Jason Received on Mon Apr 03 2000 - 00:00:00 CDT