Hi,

You can try by turning Forced writes off on the database. Firebird does
very frequent writes to it's transaction pages and that is overkill for
SSD. Without good write cache this hurts performance a lot.

I suggest you do the above only to test and see is there any difference
in the performance.

Another option I use is SSD in PCIE with database forced write OFF and
replication of that database on regular SSD or HDD where forced write is
ON. This is possible because replication does not use many transactions
to transfer data between databases.

There is a chance that your database can loose some data in case of
power failure but that will be limited up to the data that was not
replicated on the other database.

Replication on every minute is OK for databases that don't process to
many transactions.

Also if your server is protected by UPS which should be the case for
every production system then you probably can do normal shutdown
procedure so the chance to loose data is decreased.

On 11.4.2018 �. 8:33, ma_golyo@... [firebird-support] wrote:
> Hi!
>
> Do not use software RAID, it has no disc cache and IO becomes terribly
> slow. You have to use harware RAID with BBU ho have disc cache and good
> performance.
>
>


--
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116


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