At 05:14 AM 5/26/2004, Fabrice Aeschbacher wrote:

>I want the instance of the fb_inet_server process associated with the
>connection doing the SELECTs (conn2) to be started with a lower
>priority (say: nice 10).

That's a really bad idea. The two processes will be sharing database
pages and if the select process is starved, it won't be able to release
page locks on index pages so the insert process will stall. Generally,
the operating system does a much better job than a human at setting
priorities among processes that interact.

Regards,


Ann