Hello,
A couple of questions about in memory databases and performance. 1. Can an in memory database be attached to another in memory database? (Seems not). 2. Does it make sense that I should see poor performance when I attach a file database to a main in memory database when doing queries that span tables in in-memory db and attached db file? I have a main in-mem db and attach a file db. I do a select query which references tables in both dbs. I'm finding that the sqlite3_step() call takes about 50 ms with this configuration, but only takes about 10 ms using the same query when in memory database is not used and both dbs are disk files. Does this make any sense? Are there performance issues with in-memory databases that I should be aware of? The reason for going to in-mem dbs was to improve performance on a flash disk system with very slow flash disk performance. -Randy
