I have a database with 11 tables and a total of about 200k rows among them. While I would not ordinarily put such a db in memory, I decided to experiment with the :memory: version of the db. What I see is that this db occupies about 39MB on disk, but as :memory: it pushes the sqlite command-line app memory usage up to around 98MB!
Breaking each individual table out into a separate db for comparison, I see that each one takes up more room in memory than on disk -- anywhere from 40% - 300% more. Any thoughts as to why this is? What factors contribute to making a db so much bigger in memory than on disk, and what might I be able to tweak to minimize this?
I had been contemplating using the full db on disk on systems with disks, and then a smaller subset of the db in memory on diskless systems. However, if the in-memory usage is that much bigger, my subset has to become that much smaller...
Thanks in advance for any thoughts, --Brett
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
