Subject Re: Can we, can we, can we????...
Author Aleksey Karyakin
"Jim Starkey" <jas@...> wrote in message

> The feature request that sparked this thread was looking for a
> to catch runaway requests from bad programmers. Perhaps other
> have different experiences, but while I have known many bad
> I have never met a bad programmer who didn't think he was an
> exceptionally clever programmer. So I have to wonder whether a
> designed only for bad programmers will ever get used.

You are right so we have to assume that all programmers are good.
Then, may we separate two different problems:

1. A good user have changed his mind and have wanted to cancel a
query just after he realized a missed join condition.
2. A good admin wants bad users aren't allowed to bring a server down
starting a hard query every second thus letting good users to feel

Imho, the former problem is practically solvable but I'm not sure
about the latter.

The latter one should employ some resource management/limitation
scheme, taking into account page fetches, CPU time, kW*h of power
consumed, etc per user account. A good idea would be valuation of all
these resources in money units and provide a daily bill to user.

Aleksey Karyakin