Subject | Re: [firebird-support] Reduce query/transaction priority |
---|---|
Author | Aurimas Černius |
Post date | 2008-01-15T12:12:55Z |
Hello,
--
Aurimas
>> 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 forThanks for your tips. Classic server does everything just as I need.
> 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/
--
Aurimas