Re: [sqlite] How to decrease IO usage

Hi Simon, I include all the operation made by my action (so open/close are included). I create one base per user, so I prefer not to merge database to make one bigger. Thanks for your help. -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-decrease-IO-usage-tp66474p

Re: [sqlite] How to decrease IO usage

Hi Igor, Well it's a interesting solution, and I already explored this possibility. Now, it will be too expansive and complicated for us to migrate data from sqlite to nosql solution. We choose sqlite about 5 years ago, when nosql was not an industrial solution. Sqlite was the best choice. Now w

Re: [sqlite] How to decrease IO usage

Hi Michael, Thanks for your feed back, but as far as I understand the pragma cache size, it's only increase the cache size during the session. But the cache is deleted when the database is close. In my case, I only make short transaction on the database, like open, read and immediately close. I c

[sqlite] How to decrease IO usage

Hi there, Let me explain you my problem. I'm working with a lot of sqlite base (many million), but they are very small, 2000 entries for the bigger. In this base, I create 6 tables, but I mostly work on just one of them. My structure are very simple, I stored varchar and blob. My amount of inse