I agree. Thank you all.
On Thu, Jul 30, 2015 at 3:44 PM, Clemens Ladisch <clemens at ladisch.de> wrote: > James Qian Wang wrote: > > 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=?) > > There is no more efficient way to execute this query. > > > both very slow > > What file system? What disks? Any network? > > > 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
