How put the entire database on RAM Disk?



De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de karolbieniaszewski
Enviada em: terça-feira, 20 de dezembro de 2011 11:54
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: Optimizing Firebird for SSD





In your scenario SSD is not good
SSD is good for speed read but writes are problematic - slow and limit count

For database purpose, and high insert load i use only RAID 1 or RAID 10
and never RAID 5.
Use speed SAS drives with good RAID hardware with battery pack and your
problems are gone - of course you can also optimize software

You must also set big DefaultDBCache - will be good to see the same size as
DBSize on disc - then your disk live and speed will be the best

you can also do strategy like this
put whole database on RAM Disc and do backup in some accepted interval

- but i do not know your business rules - how much data loos is "acceptable"
when power or hardware error occur

Karol Bieniaszewski





[Non-text portions of this message have been removed]