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 Babuskov
http://www.guacosoft.com