I have fiebird 1.5.4, database about 20GB, 2xXeon 3GHz,2GB RAM and I
need to make calculations by stored procedure on 100k records table
with many necessary calculations on fev additional tables. It spends
about an hour. How can I improve speed of calculations large amount of
data? Bigger server? More RAM, other .....When I divide calculations
from one procedure to f.ex. four starting in the same time - it hives
me no positive efect.
Somebody, who have big databases and many calculations can help me?
Procedure is maximally clear, optimized.

Sincerelly
Wojtek