> 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.
create a memory database, attach the file based database, insert using a select as the data source and it should work pretty well.