Subject | Performance regarding hard drive |
---|---|
Author | Steffen Heil (Mailinglisten) |
Post date | 2018-02-21T17:46:41Z |
Hi
I am trying to figure out, how to configure my system to get good performance.
I am using
- Linux (kernel 4.12/4.14)
- Firebird 3.0.2 (3.0.3 soon)
- database files on ex4 volumes
For safety reasons I have
- mounted the filesystem with data=journal
- enabled forced writes in firebird
Now writing to the database is very slow, especially if the database is in backup mode and firebird is writing to a .delta file.
What in firebird.sql is important and what could I change (without risking data) to improve performance?
Regards,
Steffen
I am trying to figure out, how to configure my system to get good performance.
I am using
- Linux (kernel 4.12/4.14)
- Firebird 3.0.2 (3.0.3 soon)
- database files on ex4 volumes
For safety reasons I have
- mounted the filesystem with data=journal
- enabled forced writes in firebird
Now writing to the database is very slow, especially if the database is in backup mode and firebird is writing to a .delta file.
What in firebird.sql is important and what could I change (without risking data) to improve performance?
Regards,
Steffen