| Subject | Reduce query/transaction priority |
|---|---|
| Author | Aurimas Černius |
| Post date | 2008-01-11T09:05:51Z |
Hello everybody,
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.
--
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.
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.
--
Aurimas