| Subject | How to put an entire Database in memory using cache? |
|---|---|
| Author | Marcelo Caetano |
| Post date | 2011-09-19T23:59:52Z |
I have a Firebird 2.5 server running in a Windows Server 2008 64bit. The
server have 16 cpu cores and 16GB of RAM. The database file have 3099MB of
size and I have 2% of writes against 98% of reads of all I/O requisitions.
How can I put the entire database (or the most part) in memory by adjusting
the Page Size, Cache Size and the DefaultDbCachePages parameter? Is it
possible?
Marcelo Caetano
[Non-text portions of this message have been removed]
server have 16 cpu cores and 16GB of RAM. The database file have 3099MB of
size and I have 2% of writes against 98% of reads of all I/O requisitions.
How can I put the entire database (or the most part) in memory by adjusting
the Page Size, Cache Size and the DefaultDbCachePages parameter? Is it
possible?
Marcelo Caetano
[Non-text portions of this message have been removed]