|Subject||Re: [firebird-support] Re: FB database in RAM - Email found in subject|
>> 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. ;-(Firebird uses RAM for different purposes
>> 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. http://www.romexsoftware.com/en-us/vsuite-ramdisk/ramdisk-comparison.html
> 2. http://memory.dataram.com/products-and-services/software/ramdisk
- 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.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server