>> 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. http://www.romexsoftware.com/en-us/vsuite-ramdisk/ramdisk-comparison.html
> 2. http://memory.dataram.com/products-and-services/software/ramdisk

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
http://www.upscene.com
http://blog.upscene.com/thomas/

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