Hello! See some tests here: http://geomapx.blogspot.com/2009/11/tests-of-zlib-patched-fts3.html
The quick results: 1. The metadata compression is not useful. I think the metadata realization is nice. 2. The documents compression decreasing speed of count(*) selects. I think it's error in FTS3 virtual table realisation or in my compression code. 3. The database size by compressing a documents is decreased about 3x factor on my test docset. 4. The speed of selecting documents snippets is de-facto independent of the documents compression. The patch for the only documents compression is added to http://geomapx.blogspot.com/2009/11/fts3-compression.html Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
