SQLite Forum

how to set/test wear level algorithm using SQLite DB.
Login

how to set/test wear level algorithm using SQLite DB.

(1) By siva (SivaSubrahmanyam.Nallamalli) on 2021-06-24 15:45:19 [link] [source]

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

(2) By Warren Young (wyoung) on 2021-06-24 17:35:21 in reply to 1 [source]

Is there any sqlite option/command to batch multiple commits?

Your prior respondent gave you the answer: use SQLite's transactions feature.