Subject | Re: Optimizing Firebird for SSD |
---|---|
Author | karolbieniaszewski |
Post date | 2011-12-20T13:53:56Z |
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
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