Open Bug 1912795 Opened 2 months ago Updated 2 months ago

Consider using `SQLITE_FCNTL_CHUNK_SIZE` for growing key-value databases in chunks

Categories

(Core :: SQLite and Embedded Database Bindings, task, P3)

Product:
Core
Component:
SQLite and Embedded Database Bindings
Type:
task

Tracking

()

People

(Reporter: lina, Unassigned)

References

(Blocks 1 open bug)

Details

Marco points out in this review comment that we could use sqlite3_file_control(..., SQLITE_FCNTL_CHUNK_SIZE) to grow the database by 50 KiB, speeding up batch insertions and avoiding fragmentation.

Rusqlite doesn't currently expose a binding for sqlite3_file_control, but we could request (or contribute) it, especially if we can demonstrate cases where it brings good improvements for us.

Product: Toolkit → Core
You need to log in before you can comment on or make changes to this bug.