Subject | Re: [firebird-support] How to put an entire Database in memory using cache? |
---|---|
Author | Ricardo Uzcategui |
Post date | 2011-09-20T04:49:20Z |
if you want to risk your data, use RAMDISK.. but, it's come so fast our
querys...
http://www.softperfect.com/products/ramdisk/
Remember.. use the shadow to ensure your data will be safe..
querys...
http://www.softperfect.com/products/ramdisk/
Remember.. use the shadow to ensure your data will be safe..
On Mon, Sep 19, 2011 at 8:12 PM, Leyne, Sean <Sean@...>wrote:
> **
>
>
> Marcelo,
>
>
> > 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?
>
> Over 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.
>
> Sean
>
>
>
--
Ricardo...
[Non-text portions of this message have been removed]