I've noticed two things.
In one transaction i was writing:
- 8364 x byte structures.
- 1081 x byte structures.
- 1122 x byte (date entries).
- Approximately 8364 nested tables.
All nested tables had Technical_SetTable_OverwriteIsNotAllowed() set.
When I transaction.commit ()-ed
Transaction commit took 958346ms (958 seconds).
When I was observing what was going on was mostly writing small chunks to the .rol file.
610716 bytes - 10000018.rol as You can see rol file is not that big, but it was writing to it
When I attempted this the first time I stopped it at like 200 seconds of work. Restarted the
program. It was taking a lot of time to boot dbreeze. Probably working on .rol file.
I wonder why so many small .rol writes. And such a long time to process rol files.