python+sqlite3 in memory database
benjamin at python.org
Mon Aug 30 21:51:34 CEST 2010
Denis Gomes <denisg640 <at> gmail.com> writes:
> Hey Benjamin,
> Take a look at this website I found about cached and in-memory databases. I
think the gist of the article is that caching is good if you are doing SELECTs
on data that is frequently used whereas in-memory speeds up writes, (inserts and
updates) to the db as well as querying. Maybe I am missing something?
Well, of course, but there's little point to doing INSERTs and UPDATEs if you
don't write them to disk at some point. You could just have a long running
transaction which will not write to the database file (though depending on how
you have sqlite setup it may write to a journal file) until you commit it.
More information about the Python-list