On Sat, Oct 29, 2011 at 2:18 PM, DaB. WP@daniel.baur4.info wrote:
Hello, At Saturday 29 October 2011 15:04:30 DaB. wrote:
This queries, and others like it, have not caused problems for the last one (two? I can't remember) years they've been in place. Something has changed for the far, far worse.
have you ever thought about the possiblity that maybe there are more users on the TS and more people who use the toolserver now than 2 years ago?
Unless there was an enormous influx of users in the last 12 hours or so, this is not really an explanation.
Or maybe it is just people like you, who let a query for a WEBTOOL run for 71 minutes!
If you look at the rather simple query, you'll see that it's not so much that my tool needs 71 minutes to run. The issue is rather that the database server takes 71 minutes for a query that shouldn't even take 71 seconds.
We are just short on hardware at the moment, and the situation will not change for some time, so we all have to live with the things we have and if a tool breaks because it consumes too much resources, then the dev. has to look if he/she can optimize it or it breaks!
The "work smarter, not harder" approach is neither helpful nor winning many sympathies.
I am aware that the toolserver needs both hardware and admin attention. I was not complaining about a lack of either. I was merely commenting on a very recent change for the worse, which might have an unrelated cause (a disk filled up, some configuration changed), and might thus have an easy fix. Yelling at people who mention a new and acute issue is not the way forward.
Magnus