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