I am developing a game on Xbox360 using Sqlite for a lot of our data manipulation. We use the ':memory:' functionality to create our DB in RAM, because we need our DB manipulations to be very fast - we can't afford for our queries to cause seeks/loads on the DVD.
This works very well for us with one exception: It takes a long time to load the DB. Since we need the DB to be in memory, we create an empty ':memory:' DB, then load up a file which contains all the SQL (CREATE TABLE, INSERT INTO) we need to create our tables and execute them on the memory-DB. This process currently takes 10 seconds (all running the SQL statements to create the tables), which is not acceptable for our game. Is there a way to load a Sqlite file based DB and then specify we want that to go into memory? Or is there a more efficient way to create our memory DB? Thank you very much for your help, Dave Gierok
