Hi,

> This is an EXECUTEable proc, returning nothing, so I should not use SUSPEND.
>
> Do (or anyone) have a suggestion as to how I can tell the stored proc to not bring my server to it's knees for 3 full minutes?
>
> I want FB to be given high(est) level thread priority in the OS, except for this one procedure, I'd like FB to rather "mozy along", and serve other user's requests first and get back to this thread when it can.

What is your procedure doing? How does the execution plan look like etc ...?

Unfortunately, Firebird doesn't offer configurable "resource pools" to
configure e.g. max allotted CPU usage etc. like in Oracle, SQL Server etc.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/