Hi, I've read a lot of mails on this group regarding use of Sqlite in-memory mode, for better performance.
Currently we're using file based Sqlite DB and are facing lot of performance issues since the DB file is accessed a zillion times in a single program run. I've decided to try out the in-memory Sqlite DB to see the performance differences. Could someone please point me to any documentation regarding these - 1. How to use in-memory DB. 2. Do the same type of sqlite query functions work for file based DB's and in-memory DB's? 3. If I need to save my memory based DB to a file then how do i do this. 4. Once saved to a file I might even need to open the file and put it back in memory to get the same performance as before - is this possible? -- Regards, ritesh