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
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
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
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
4 matches
Mail list logo