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
> 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.
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
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.
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:
5 matches
Mail list logo