Hello,

Im running Firebird 2.1 in "Classic-Server" mode on a not-so-bad Windows machine, but it looks like FB doesn't make really good use of my system. It's main hardware is an Intel P4 @ 3Ghz CPU, 4g of RAM and fast RAID SATA drives - But when I execute huge queries, or large INSERTS, the FB server causes a CPU load of max ~30% and RAM usage of only a few megs. How to assign more resources to Firebird? I would give it 80% of all my system resources if it would help to improve performance but I don't know where to start.
The main tasks of my database is repeatedly doing queries like

SELECT COUNT(*) CNT, MAX(FLD) MXF, MIN(FLD) MNF FROM MYTABLE WHERE KEY = 'ABC12345';

Simple stuff - Nevertheless, performance is critical since this is being executed on a table containing > 5 million records (in the future it'll be ~10 to 50 million). Key fields are - of course - indexed :)

Which parameters would be the best to improve the operations mentioned above?

Greetings