python+sqlite3 in memory database

Benjamin Peterson benjamin at
Tue Aug 31 00:27:16 CEST 2010

John Nagle <nagle <at>> writes:
>     "sqlite" has reasonably good SELECT performance on simple indices,
> but anything beyond that isn't all that great.  Multiple processes
> updating the same sqlite database will have terrible performance,
> because the locking mechanism not only locks the entire table,
> the wait mechanism is a timed retry.

This is been improved significantly in recent versions with support for write
ahead logging and different lock levels to prevent writer starvation.

More information about the Python-list mailing list