Re: [sqlite] Updated FTS3 compression patch

[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 top of 2.6.23's source, or even better amalgamation?

There are a lot of ways to get diff:

1. The diff is available from repository:
http://sqlite.mobigroup.ru/src/ci/d3d9906674

2. The diffs for single files are available from repository:
http://sqlite.mobigroup.ru/src/fdiff?v1=31896=31918
http://sqlite.mobigroup.ru/src/fdiff?v1=31743=31919

3. Or you can download files before and after the check-in and make diff
manually. See links on the page 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

[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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Updated FTS3 compression patch

[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

[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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Updated FTS3 compression patch

[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: user 0.004000 sys 0.00

Really, unpacking full database content is slow operation. Is it possible to 
fix this
on virtual-table level?

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