[sqlite] Query tooooo sloooooooooow

[Clemens Ladisch]

James Qian Wang wrote:
> select count(*) from contact c left join history h on (h.elid=c.elid);

Please show the output of EXPLAIN QUERY PLAN for this query.

If it does not look like this:
  0|0|0|SCAN TABLE contact AS c USING COVERING INDEX elid2
  0|1|1|SEARCH TABLE history AS h USING COVERING INDEX elid (elid=?)
you should get a newer SQLite version.


Regards,
Clemens