"James K. Lowden" wrote...
On Wed, 23 Jul 2014 20:00:52 -0600
"Keith Medcalf" <kmedc...@dessus.com> wrote:
BEGIN;
INSERT OR REPLACE INTO LSOpenProjects
SELECT * FROM client.LSOpenProjects as A
WHERE A.ProjID <= 133560 AND
Date != A.Date AND
A.login = 'user1';
END;
I presume that LSOpenProjects in both databases has a unique
constraint on ProjID, Date, and login ...
That BEGIN/END should be superfluous because INSERT...SELECT is a
single atomic statement. Is there something about SQLite that makes it
necessary, or was it just for illustrative purposes?
I learned in this list that BEGIN/END speeds up the inserts by blocking the
write mode to the DB. I was getting a lot of SQLITE_BUSY and these
BEGIN/END got rid of 99% of them.
jic
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users