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 is being used? If the extra time is inside of inflate() (or whatever other decompression algorithm you are using) or within rijndaelDecrypt() (or whatever other decryption algorithm you are using) then probably your only solution will be to disable encryption and/or compression. There is an engineering trade-off here. Please run your system in a profiler and send us the results. Perhaps we can spot other opportunities to improve performance. Also please send as many details about your system as possible. What kind of hardware are you using? What operating system? Which compression and encryption algorithms are you using? How large is your dataset? What kinds of queries are you running? Which specific version of the NDS dev-kit are you running? Probably you should send us the above information through your secure NDS support channel, rather than here in this public forum. -- D. Richard Hipp drh at sqlite.org