How slow is too slow? -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of James Qian Wang Sent: Thursday, July 30, 2015 5:13 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Query tooooo sloooooooooow
my desktop (windows 7) SQLite version 3.8.7.4 2014-12-09 01:34:36 and explain query plan showed: 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=?) my linux box needs upgrade. regardless, both very slow On Thu, Jul 30, 2015 at 11:03 AM, Clemens Ladisch <clemens at ladisch.de> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- James Qian Wang Mobile: 44 7986 099 233 _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.