Having just glanced at the documentation for ZIPVFS (didn't even know it existed)...
1) Perhaps using a real-time compression algorithm, something like lz4. It's not clear to me which algorithm ZIPVFS uses by default. 2) Perhaps increasing the cache settings to cache more pages in memory. 3) Perhaps increasing the page size. 4) Perhaps ensure that WAL mode is used. -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of ??? Sent: Wednesday, December 23, 2015 4:05 AM To: sqlite-users at mailinglists.sqlite.org Subject: [sqlite] In the case of ZIPVFS HI,all SQLite retrieves the compressed records is slower than the uncompressed records about 30%. How can improve the problem? and anyone any suggustion? best regards wqg _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
