Quoth Simon Friis <simo...@gmail.com>, on 2011-03-21 14:13:46 +0100: > Is is possible to make SQLite load a database file into memory and > then save it back to the file again when the connection to the > database is closed?
You cannot do that with a single database exactly, but you can use the Online Backup API <http://sqlite.org/backup.html> to copy all data from a file database into a memory database and then copy the new data back when you are finished. > Would it improve speed? That depends on your application. In general if you think too many file accesses is a speed problem and you are willing to spend more memory to deal with it, some of the first things to try would be fiddling with the cache_size, synchronous, and journal_mode PRAGMAs, depending on what tradeoffs you want to make. > - paldepind ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users