| Subject | RE: [firebird-support] How to put an entire Database in memory using cache? |
|---|---|
| Author | Leyne, Sean |
| Post date | 2011-09-20T00:42:57Z |
Marcelo,
Sean
> I have a Firebird 2.5 server running in a Windows Server 2008 64bit. TheOver time the Windows OS will effectively have the entire database in its page cache, so I don't think there is anything you really need to do.
> 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?
Sean