Re: [sqlite] Updated FTS3 compression patch

2010-03-25 Thread Alexey Pechnikov
Hello! On Thursday 25 March 2010 08:29:45 Alexandre Courbot wrote: > > Patch is here > > http://sqlite.mobigroup.ru/src/vinfo/d3d9906674 > > Would love to try it - but for some reason I cannot find a way to get > an actual "patch" on this page. Could you produce a diff that could be > applied on

Re: [sqlite] Updated FTS3 compression patch

2010-03-24 Thread Alexandre Courbot
> Patch is here > http://sqlite.mobigroup.ru/src/vinfo/d3d9906674 Would love to try it - but for some reason I cannot find a way to get an actual "patch" on this page. Could you produce a diff that could be applied on top of 2.6.23's source, or even better amalgamation? Thanks, Alex.

Re: [sqlite] Updated FTS3 compression patch

2010-03-19 Thread Alexey Pechnikov
Hello! Patch is here http://sqlite.mobigroup.ru/src/vinfo/d3d9906674 Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Updated FTS3 compression patch

2010-03-18 Thread Simon Slavin
On 18 Mar 2010, at 4:35pm, Alexey Pechnikov wrote: > sqlite> select count(*) from file_text; > 8430 > CPU Time: user 0.508032 sys 0.012000 Try counting just the primary key. Suppose your primary key is a column called 'id', try SELECT COUNT(id) FROM file_text Simon.

[sqlite] Updated FTS3 compression patch

2010-03-18 Thread Alexey Pechnikov
Hello! I did rewrite the subj and now my test database is 4.6x smaller. It's fine, of cource. But there is the problem with speed of count(*) query: sqlite> select count(*) from file_text; 8430 CPU Time: user 0.508032 sys 0.012000 sqlite> select count(*) from file_text_content; 8430 CPU Time: