On Mon, Sep 6, 2010 at 7:25 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 7 Sep 2010, at 12:21am, Richard wrote: > > > I was wondering if there's a method to directly load a disk DB into > memory. I'm aware of 2 indirect methods, namely: > > > > > > - create a .dump and .read the created file > > > > > > - attach the disk DB and insert the disk tables into memory tables > > Assuming you mean to use the INSERT ... SELECT form of the command to load > into :memory:, that's probably the fastest way to do it. It might > theoretically be possible to block-load the file into memory but I don't > know of a standard way to do this. > The backup API does block loading. More information at http://www.sqlite.org/backup.html > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
