Subject Re: SUSPEND
Author red_october2009
Hi André
> You did not write, which server version you are using and on which
> hardware.


> I have one intensively used ClassicServer 1.5.6 (...yeah... *am* in
> the process of migrating to 2.5.2) running on a dedicated machine with
> Windows2003 OS. 4 GB Ram only, which seems ridiculously little today.

Never feel bad about using old hardware or old FB. FB is very efficient and doesn't need a whole lot. If the user group is happy, FB version is not relevant.

Each time the stored proc is run it has to delete about 30K records and add just over a million records.