Thanks for the reply
What I need to know is if there is a way to prevent the server from geting
stuck after a missbehave query like the example is sent?
The problem is all other clients go so slow that no work can be done and
no new connections can be made.
The server is a DUAL XEON 3GH 1GB RAM,
[EMAIL PROTECTED] wrote:
> Hi
>
> I need to prevent users from holding down the server,issuing the next
> query the server becomes so slow that the other clients can't even login!,
> the tables are around 6Million records:
>
> SELECT (some fields ), sum(more fields) AS calcfield
> FROM table1
