Lock-free reads -- Separate read-only file handle uses pread. Writes are serialized via Mutex.
Lazy sync mode -- Background thread batches fsyncs at a configurable interval. Reduces write latency at the cost of durability window.
Collection Isolation
Each collection has its own storage file, WAL, indexes, and cache. Per-collection RwLock enables concurrent reads across different collections and concurrent reads within the same collection.