Subject Re: [firebird-support] Re: FB database in RAM - Email found in subject
Author Thomas Steinmaurer
>> P.S. I tried to install RamDisk software on my Window 7 system in order to benchmark a RamDisk against my local Crucial C300 SSD, unfortunately, the RamDisk software kept generating BSODs. ;-(
>> I will forward some numbers if I can get a stable environment.
> What RamDisk do you use and how big RAM do you have and how big RAM disk you create? And on what OS ;-) You must remember to not create bigger disk then = avaiable memory - OS use.
> i can recommend you two solution for Windows:
> 1.
> 2.

Firebird uses RAM for different purposes

- Caching pages
- Temporary data
- Lock table

While configuring the page cache is well-known, Firebird provides
configuration parameters for caching temporary data used in sort/merge
operations as well. To be found in firebird.conf. But, these settings
are in Classic/SuperClassic per connection, so often hard to deal with,
especially for not getting near to a swap to disk scenario.

So, basically I like to have a RAM disk for temporary data, which usage
can be configured per Firebird instance in firebird.conf.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!