assuming you open up a :memory: database: attach 'foo.db' as bar; create table baz as select * from bar.baz; detach bar;
doesn't copy indexes, so you'll have to remake them. dont think it copies triggers either. On 7/6/05, John Duprey <[EMAIL PROTECTED]> wrote: > Is it possible to load an SQLite file database into an SQLite "in > memory" database? If so what is the most efficient method to do this? > I'm looking for the fastest possible performance. Taking out the > disk I/O seems like the way to go. > > Thanks, > -John > -- Cory Nelson http://www.int64.org
