Hi,

At February 8, 2005, 06:22, chriskudla wrote:

> I have a customer who needs to be able to print an 80 page report at
> various times during the day. Understandably it takes several minutes
> to run the SQL query to get the data for this report. The problem
> comes in for the other 5 users in the system that are busy capturing
> data – everything slows down drastically for them. Even if this
> report is optimised down to less than a couple of minutes, it is
> still unacceptable for the other users.
> Is there any way of preventing this report from hogging all the
> resources, so that other smaller queries can run in between? (A bit
> like what Application.ProcessMessages does for you within a loop in
> Delphi)

Which version of Firebird are you using? With FB 1.5x, you can tweak
the thread scheduling for your scenario(information in Firebird.conf
and the release notes).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)