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 can't maintain the session active. But, one of my possible solution is to put database in memory, with vmstat for example. It will produce something similar, because all the data will be in memory. However, I'm looking for sqlite solutions. I can get around of my latence problem with system solution, but if I can optimize my solr usage, it will be better. I feel that my usage is not as optimal as it could be. -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-decrease-IO-usage-tp66474p66494.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users