| 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