Subject Re: [firebird-support] Re: Optimizing Firebird for SSD
Author Ann Harrison
On Fri, Dec 30, 2011 at 2:45 AM, Doychin <doychin@...> wrote:
> If you use Linux as Database OS you can create ram disk very easy. It is part of the OS. There is no limitation for the size. Only the available RAM memory is your limit.
>
> When you use RAM disk you can set the size of your database cache to some small value because all data is already in the RAM.

Be careful with that because Firebird will copy pages to its cache
before referencing their contents. If you make the database cache too
small, you'll spend a lot of cycles doing memory to memory copies.
Lots cheaper than disk reads, of course, but not free.

Good luck,

Ann