python+sqlite3 in memory database

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


John Nagle <nagle <at> animats.com> 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