Subject | Getting the server to share resources better |
---|---|
Author | C Fraser |
Post date | 2002-09-16T05:42:04Z |
Hi all,
Is there a way to make IB/Firebird better at sharing CPU resource
between queries?
We can have client apps here issuing long queries that just slow the
rest of the IB/Firebird client right down to basically non
functioning... Just logging on can take ages.
We have one particular app that basically needs to have relatively
speedy access to the server as it controls some hardware. Is there a way
that we can help guarantee that app a bit better chunk of CPU time or
even better, stop other queries taking up 99.99 % of the CPU time and
starving the rest???
Any info appreciated.
Regards
Colin
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################
Is there a way to make IB/Firebird better at sharing CPU resource
between queries?
We can have client apps here issuing long queries that just slow the
rest of the IB/Firebird client right down to basically non
functioning... Just logging on can take ages.
We have one particular app that basically needs to have relatively
speedy access to the server as it controls some hardware. Is there a way
that we can help guarantee that app a bit better chunk of CPU time or
even better, stop other queries taking up 99.99 % of the CPU time and
starving the rest???
Any info appreciated.
Regards
Colin
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################