Subject Db performance
Author Marek Konitz
Hi.

I'm running database with ca 10M records in address book table and up to
30 concurrent connections. The server is FB 1.5.2 SuperServer on P4HT
machine with 1,5GB RAM.
It's extremely slow by now, and consumes almost 50% of CPU (100% of one
virtual processor).
And TaskManager shows, that it allocates only about 10MB of memory.

Should I in this case switch to ClassicServer?

What buffers should I increase to force it to use more memory?

Regards,

Marek Konitz