[sqlite] In the case of ZIPVFS

2015-12-24 Thread 王庆刚
Thank you very much. At 2015-12-23 17:32:26, "Richard Hipp" wrote: >On 12/23/15, ??? <2004wqg2008 at 163.com> wrote: >> HI,all >> SQLite retrieves the compressed records is slower than the uncompressed >> records about 30%. >> How can improve the problem? and anyone any suggustion? >>

[sqlite] In the case of ZIPVFS

2015-12-23 Thread Michael Stephenson
e-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] In the case of ZIPVFS

2015-12-23 Thread 王庆刚
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] In the case of ZIPVFS

2015-12-23 Thread Dominique Pellé
??? <2004wqg2008 at 163.com> wrote: > 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 What is your SQLite page size? If you access small recor

[sqlite] In the case of ZIPVFS

2015-12-23 Thread Richard Hipp
On 12/23/15, ??? <2004wqg2008 at 163.com> wrote: > HI,all > SQLite retrieves the compressed records is slower than the uncompressed > records about 30%. > How can improve the problem? and anyone any suggustion? > Have you run your system in a profiler to determine where the extra 30% time