Leonid Safronie wrote:
> Hi, ppl
>
> Is there any way to do SELECTs with different priorities?
> The issue is that response time for
> these 50 processes is very important unlike for report generation, and
> time spent by these processes while report running is unacceptable for
> my production environment (response time grows from 1-3 seconds up to
> 1-2 minutes).
The most important question is why response time drops so much? Does it
look like it's disk I/O that's the problem?
--
Richard Huxton
Archonet Ltd