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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
