> What will be very interesting re journalling - compare interbase with
> journalling and async writes vs. interbase without journalling and sync
> writes.
> This can give us an idea what effect does journalling give.
Actually in order to be failsafe, journaling would also need to use sync/full
log details.
The difference is that journaling creates a sequential write stream which is
lazily converted into random writes to the pages. Whereas all Firebird
(non-sort file) writes are random.
Sequential IO always performs at least an order of magnitude faster than random
IO on all storage devices (excluding perhaps Intel's Optane DIMMs).
All that said, as with all benchmarks... "the devil is in the details"...
What storage device were used HDD? SATA SSD? NVMe SSD?
What database page size and cache settings?
Sean
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
