Re: [sqlite] In-memory database with persistent storage

..representation of a decent sized real world network.. On Tue, Mar 22, 2011 at 10:59 AM, Bart Smissaert wrote: > > through a version of dijkstra's routing algorithm > > Just out of interest, what data is this working on? > > RBS > > On Tue, Mar 22, 2011 at 7:25 AM, Amit Chaudhuri > wrote: > > [

Re: [sqlite] In-memory database with persistent storage

> through a version of dijkstra's routing algorithm Just out of interest, what data is this working on? RBS On Tue, Mar 22, 2011 at 7:25 AM, Amit Chaudhuri wrote: > [Not at all expert in sqlite but here's a practical example of speed up > using ":memory:" and perhaps a slightly different strate

Re: [sqlite] In-memory database with persistent storage

[Not at all expert in sqlite but here's a practical example of speed up using ":memory:" and perhaps a slightly different strategy for getting at the persistent data.] I use sqlite3 with Qt4 / C++ for an application which reads in an undirected graph and then chunks through a version of dijkstra's

Re: [sqlite] In-memory database with persistent storage

Thanks! The Online Backup API does exactly what I want. 2011/3/21 Drake Wilson : > 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

Re: [sqlite] In-memory database with persistent storage

Quoth Simon Friis , 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

Re: [sqlite] In-memory database with persistent storage

Simon Friis wrote: > I know how to create a database that exists only in memory by using > the :memory: filename. This however, creates a new database every time > and it can not be saved. It can, with backup API: http://www.sqlite.org/backup.html > Is is possible to make SQLite load a database

[sqlite] In-memory database with persistent storage

I know how to create a database that exists only in memory by using the :memory: filename. This however, creates a new database every time and it can not be saved. 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 data