Our application has some processes that run for an extended period of
time(up to 4 or 5 hours) as there is alot of complicated calculations.
These processes are written with Stored Procedures (One main
procedure that may call many other procedures.)

We are experiencing problems where when these procedures are running,
they take over the server. IBServer shows it is taking 99% of the CPU
causing all other users to virtually stop when trying to access the
server.

We experience a similiar problem when users run complicated queries.

1) Is it adviseable to process these types of calculations in Stored
Procedures or should they be written in C++?

2) Is there something we can do to ensure the server isn't taken over
by Firebird?

Any help would be appreciated.

Todd Brasseur
COMPASS Municipal Services Inc.