Subject Re: [firebird-support] Classic process priority
Author Ann W. Harrison
JD FitzGerald wrote:
> Does anyone know how to increase the priority of the classic server
> processes on Win 2000 server? FB version 1.5.2

Playing with priorities on Classic normally makes things worse. In
classic, it's really important that any process that has a page in cache
be able to respond quickly to a signal to release it. Starving any one
process will lock up every process.

>
> The reason behind this all is that there was a pretty hefty stored
> procedure in the db that has to be run once an hour.

Is the procedure compute bound or I/O bound?


Regards,


Ann