"big stone" wrote...
hi Jose,
The SQL request with a "in()" that is improved by 5x in the latest beta
is of form :
select * from a , b where a.field1 in (b.column1, b.column2, b.column3,
b.column4, 'fixed value')
Hi Big Stone,
This is what I am running with an ATTACHed DB as client...
BEGIN;
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
);
END;
It has not shown any speed improvement, but maybe the slowdown is caused by
the INSERT.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users