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)