The recent thread may relate: "[sqlite] Is there an efficient way to
insert unique rows (UNIQUE(a, b, c)) into an fts3 virtual table?"
INSERT INTO fts3_table (a,b,c)
SELECT 'an A','a B','a C'
WHERE NOT EXISTS
(SELECT DISTINCT a,b,c
FROM fts3_table
WHERE a='an A' AND b='a B' AND c='a C');
The above SQL could be adapted to your schema. As mentioned, the
performance will be slower than a straight insert.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users