Hi

We have noticed that when running particularly laborious SQL statements
auto generated by Crystal reports FB (SS 1.5.1.4481) seems to go up to
99% CPU utilization. When this occurs out FB application essentially
appears to come to a halt. At one users site 10 users freeze when
another user runs a report that takes about 15 minutes to run. Yes I
know the report is a problem but we have a number of other reports that
might take about a minute to run that potentially can cause the same
problem. It seems that FB isn't good at sharing its resources?

Is there a setting (max CPU utilization per SQL?) that can prevent this?

Im going home now !!!!!

--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd