when I get queries which seem to do this I do some serious work on my client
app and it's queries or the database structure. None of my client app
queries are "long", it's really not very friendly to have this situation as
you rightly comment.
Is there a real need to have such heavy queries. Do you have indexes set
correctly etc?
Alan
-----Original Message-----
From: C Fraser [mailto:Colin.Fraser@...]
Sent: Monday, 16 September 2002 15:42
To: ib-support@yahoogroups.com
Subject: [ib-support] Getting the server to share resources better


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.
######################################################################

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]