Re: [sqlite] Attach db code

First, connect to your db file. As this is the first connection this will be referred as 'main'. Then you need to attach a memory database. ATTACH DATABASE ":memory:" AS mem; Create your table definitions in memory, por example: CREATE TABLE mem.table1 (... You can get some info from: SELECT

[sqlite] Attach db code

Hi All, Can someone give me the code you use to attach a database. I have a db file with 5 Million records and have three different tables. Index is also created in it. I want to load it in memory to apply some queries for testing. Best regards, Manzoor Ilahi Tamimy