Subject Run Firebird Database In Memory?
Author kasparovimnot
We are running a 2.1 superserver db on a 64 bit CentOS Linux server. The database is about 30gb and we are experiencing bottlenecks in searching due to disk speed, despite the fact that the database is on a 15k RPM SAS array. We are building a new server to house the database that has 32gb of RAM and are wondering how to optimally configure Firebird so that as much as possible of the database is loaded into memory. Is this simply a matter of setting the page buffers? Any information would be greatly appreciated as I've found very little documentation around the web on optimizing.

Thanks for any help!