On Fri, Jul 22, 2011 at 8:55 AM, Григорий Григоренко <[email protected]>wrote:
>
>
>
> >
> > Something that might speed up your operation is to issue the SQL command
> 'ANALYZE' just once. The results are stored in the database file, so you
> can just do it manually now you have some data in the database. It gives
> the query optimizers lots of clues about how best to optimize each query. So
> do an ANALYZE, then close the database and do your timing tests again.
> >
>
>
> Well, ANALYZE has changed something. Now query is using PRIMARY KEY and
> executing almost instantly :-)
>
Please post the results of:
SELECT * FROM sqlite_stat1;
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
