[sqlite] Query tooooo sloooooooooow

[James Qian Wang]

Hi All,

Here is my query:
select count(*) from contact c left join history h on (h.elid=c.elid);

Here are the table structures:
sqlite> .schema history
CREATE TABLE history (name varchar(32), email varchar(128) unique, elid
int(12));
CREATE INDEX elid on history (elid)
;
sqlite> .schema contact
CREATE TABLE contact (name varchar(32), email varchar(128) unique , elid
int(12));
CREATE INDEX elid2 on contact (elid);

Table size:
contact 20m
history  10m

elid integer and each elid has about 20k records

Ideas please?

Thanks a lot in advance
-- 
James Qian Wang
Mobile: 44 7986 099 233