Greetings!
I have a bunch of records to check, and I am wondering which is a faster
check. I am attaching a network DB as client,
ATTACH 'h:\bkup\test.db' AS client;
and then do an INSERT based on some logic, and one of those login is
checking against a variable or an actual DB value. Here are the
different SQL syntaxes:
BEGIN;
INSERT OR REPLACE INTO OpenProjects
SELECT * FROM client.OpenProjects
WHERE id IN
(
SELECT id FROM client.OpenProjects
WHERE
client.OpenProjects.id = id AND
client.OpenProjects.ProjID <= 133560 AND
client.OpenProjects.XtraB != XtraB -- change
);
END;
BEGIN;
INSERT OR REPLACE INTO OpenProjects
SELECT * FROM client.OpenProjects
WHERE id IN
(
SELECT id FROM client.OpenProjects
WHERE
client.OpenProjects.id = id AND
client.OpenProjects.ProjID <= 133560 AND
client.OpenProjects.XtraB > '2017-02-10 00:00:00' -- change
);
END;
Any input would be greatly appreciated. Thanks.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
