Hello, We are getting ready to start using in- memory database to cache sqlite reads/writes in effort to improve speed. For background, the application is an email client.
The way we envision the caching working is that we have a mirror copy of any table in use in memory. The tables are small and not many are in use at any time, so we are ok with space. Since we read much more than we write, reading from memory should improve. Also, this should simplify our transaction model for transacted objects. Has anyone done this? Comments? Best Regards, Kervin
