Ranjitha wrote: > 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 </F> -- http://mail.python.org/mailman/listinfo/python-list