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_go...@yahoo.com [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] ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
