I'm in the process of converting a normal table to a FTS virtual table, and I'm noticing different behaviour if I try to insert duplicate rowid's. I'm using the 'INSERT OR IGNORE' statement, and on the normal table I can try to insert millions of duplicates very quickly, but on the FTS table it's very slow, and for every failed insert I get:
SQLite error (19): abort at 10 in [INSERT INTO 'main'.'table_content' VALUES(?,(?))]: PRIMARY KEY must be unique So a possibly explanation of the performance difference would be that the virtual table is sending a TRACE message for each row, but how can I disable/prevent that? Or is there another reason the virtual table is slow with duplicates? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
