Chris Kudla wrote:

> We have a developed a multi-user software package using Firebird. We find
> that if one usr is running a fairly big report the CPU Useage on the Server
> goes to 100% and all other users have a serious spped degredation when
> trying to access data at the same time.
>
> Is there any way that we can prevent Firebird giveing 100% usegage to a
> user, at the expense of other users on the network?
>

There is nothing that I know of that can be done in Fb1.0 on the server.

If you have full control over the SQL generated you may find that you
can change the cpu-intensive query so that it doesn't hog the server. Do
you know what the query is (and what kind of txn isolation you are using?)


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase