Milan Babuskov wrote:

> Aurimas Černius wrote:
>
>> I'm interrested, if there is possibility to reduce priority of query?
>> The problem is, that when one user starts a long SELECT (5 minutes, but
>> can be much longer), all other users hardly can do anything, because
>> database gets very slow.
>>
>> Is there any way, to make a query/transaction to run in lower priority
>> (thread priority or smth)? It is acceptable, that long querys get even
>> longer (up to several times), if the short ones remain fast.
>>
>> By the way, i'm running Firebird 2.0.3 on Gentoo Linux.
>>
>
> It looks like you're using SuperServer. Switch to Classic and things
> should improve a lot. If you still want more control, with Classic each
> connection is a separate process, so you can use the system 'renice'
> command to change the priority.
>
>

Milan,

IIRC Ann said that renice the process is not a good thing, some locks
will be low priority and the other process that waits for those locks
will wait more than necessary, I can't remember exactly, but I have
something on that line on my mind.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br