Repository navigation
Huge Firebird 5 impact on disk io #8833
Description
Activity
That looks to me like a write to the header page each time a transaction is started. You have a 32KiB page size by the looks of it. This is entirely expected and normal if you (or a driver in auto-commit mode) starts a new transaction for each select, and executes those selects near continuously.
And why do you think it is not correct, or problem, or ... what ?
Note, you use biggest possible database page size, also, you disabled filesystem caching - no wonder it creates some load on IO.
PS usage of read-only transactions when possible will lower header page writes.
PS usage of read-only transactions when possible will lower header page writes.
I thought that was no longer the case with ReadConsistency = 1
@hvlad Do you think this should be moved to discussions?
- locked and limited conversation to collaborators
on Dec 22, 2025
Many simple select statements cause high write load in my drive.
It's a continuous load of a few MBps.