[sqlite] NOT EXISTS and LEFT JOIN Performance problem

[Clemens Ladisch]

ShadowMarta at yahoo.de wrote:
>> You should drop the ID column, and in your queries use the docid instead.
>
> Not possible.
> I fill the rows in a parallel loop, the IDs are in disorder and they are the 
> link to table ?ART.ID?.

INSERT INTO OCR(docid, FullOCR) VALUES (42, 'xxx');


Regards,
Clemens