Re: [sqlite] Increase concurrency by attaching database files

On 5 May 2012, at 12:22pm, Marcolippo Polpettino wrote: > I've read that sqlite locks the entire database file on updates. True. This is extremely fast: checking for a lock involves checking just one thing. Making a lock involves changing just one thing. Table-level

[sqlite] Increase concurrency by attaching database files

Hello, I've read that sqlite locks the entire database file on updates. Our database is based on a very small number of tables that contain a huge amount of records (under WAL mode). Will we get improvements in performance if we create different database files (one for each table) and attach