This is continuation to previous discussion as Support was expired. [Re: Support Customer - Gator/EST4]
In the previous discussion mentioned below to batch multiple commits into a single transaction to reduce the flash writes. Is there any sqlite option/command to batch multiple commits?
I am using sqlite 3.32 version? Is there a need to enable SQLITE_ENABLE_BATCH_ATOMIC_WRITE compilation flag in this version.
> Is there way to find out how many flash writes occurs if fire panel
> writes
> 50 fire events per second (3000 event per minute) in our SQL history
> database?
What matters is transactions per second, not writes per second. A lot will depend on how you batch fire events into transactions. If you put each fire event into its own transaction, that will be a lot of writes. If you batch 10 seconds worth of fire events into a single transaction, that will be many fewer writes. You can also reduce the number of writes by using WAL mode.
We need to bring your support contract up-to-date in order to continue this conversation. Or you can ask questions on the public SQLite
forum: https://www.fossil-scm.org/forum/forum