Re: [sqlite] Slow response using WHERE - IN

2014-07-28 Thread jose isaias cabrera
Clemens Ladisch wrote... The first command is slow because the subquery generates lots of results, but because of the reference to A.Date, it is a correlated subquery and must be re-executed for each row in A. If a have understood the query correctly, you want to check whether a corresponding ro

Re: [sqlite] Slow response using WHERE - IN

2014-07-28 Thread Clemens Ladisch
jose isaias cabrera wrote: > This command, > INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects as A > WHERE id IN > ( > SELECT id from LSOpenProjects > WHERE login != 'user1' AND Date != A.Date > ); > > is about 20 slower than if I

Re: [sqlite] Slow response using WHERE - IN

2014-07-27 Thread jose isaias cabrera
Clemens Ladisch wrote... On 07/26/2014 06:22 AM, jose isaias cabrera wrote: INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date != A.Date; What is A? Sorry, this should have been written like this. INSERT OR REPLACE INTO LSOpenPr

Re: [sqlite] Slow response using WHERE - IN

2014-07-27 Thread Clemens Ladisch
On 07/26/2014 06:22 AM, jose isaias cabrera wrote: >INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date != > A.Date; What is A? Regards, Clemens ___ sqlite-users mailing list sqlite-users@s