Subject Re: [firebird-support] Re: i need your opinion...
Author Alexandre Benson Smith
Ali Gökçen wrote:

>You know, in a multiuser environment there is alot of work types.
>some of them more important and need fast response, fast insert, fast
>update(urgent tasks).
>if there is alot of user with running heavy but none-time-critical
>queries, they can create a DISC I/O bottleneck on system.
>my goal is to detain this user with CPU operations and to deffer their
>DISK I/O operations.

I think the best that could be done is let the engine finish each task
as fast as it can.

A low-priority task, could hold resources needed by a high priority
(since update critical regions of the database) and the low priority
being slow will slow down the hight priority too.

Another thing to consider, FB in the current state are sometimes CPU
bound, with you use CPU to slow downa low priority you will in fact slow
down the whole system.

I am sure the gurus will correct me if I am wrong in those statements.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil