Hello,

I have a stored procedure used to recalculate stock card on my application.

The procedure is counting by date. I mean if the user recalculate
from beginning of month than if there are data already in the
stock card table will be deleted and then the procedure will
insert record into the stock card date by date until current date.

After deleting record the firebird will increase garbage collection which slowing down the process. Is it true?
My question is how to speed up the process. I mean is it possible run the process without any transaction active that will create garbage collection.

Any suggestion...

Regards,

Ongky