mvsqlite icon indicating copy to clipboard operation
mvsqlite copied to clipboard

Custom freelist handling

Open losfair opened this issue 3 years ago • 0 comments

SQLite manages an on-disk data structure called "freelist". The freelist is used to track free pages in the database.

The head of the freelist is stored in page 0. Each page allocation/release will write to page 0, and conflict with every other concurrent transaction. This is not good for concurrency.

We should emulate a freelist instead.

losfair avatar Sep 10 '22 08:09 losfair