Subject Re: [firebird-support] Reduce query/transaction priority
Author Aurimas Černius
Hello,

>> 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.
>>
[...]
> The Firebird project is working on a better threading model for
> SuperServer which should solve the problem of one query blocking
> all others. Until the, try Classic. But do read about the resource
> use of classic and change the default page cache size/

Thanks for your tips. Classic server does everything just as I need.

--
Aurimas