Pysqlite tables in RAM
fredrik at pythonware.com
Fri Sep 29 16:34:58 CEST 2006
> I want to store my data in a database on the disk. I also want to be
> able to reload the tables into the RAM whenever I have a lot of disk
> accesses and commit the changes back to the database.
using the cache_size and synchronous pragmas sounds like a better way to
trade reliability against speed/memory use. e.g.
table_memory = 100000000 # bytes
cur.execute("pragma cache_size = %d;" % (table_memory / 1500))
cur.execute("pragma synchronous = off;")
# do lots of stuff
cur.execute("pragma synchronous = full;")
for more on this, see: http://www.sqlite.org/pragma.html
More information about the Python-list