On 15 Aug 2005 at 13:42, Ivaylo Spasov wrote:

>Does Firebird offer any priority support?

No. But your problem has another solution.

>At a specific time in the month some of the clients perform big and
>ugly queries, which take more than 30 minutes to finish and return
>results. These SQLs are blocking the server.

Try to switch to FB classic. This should solve server blocking. But
don't forget to decrease number of pages for cache if you set it on
DB level.

>Unfortunately, all these queries must be executed on the same
>database, because it is changing fast and is too big (300mb) to be
>backed up too often.

As a second level of the solution if described above is not enough,
I'd suggest replication between superserver for "ordinary" fast users
and classic for heavy reports.

--
SY, Dimitry Sibiryakov.