Subject Re: Optimizing Firebird for SSD
Author karolbieniaszewski
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