On 30 Jul 2018, at 8:38pm, Gerlando Falauto <[email protected]> wrote:
> Does that apply to the primary key as well? Primary key indexes are unique indexes, since SQLite has to enforce the primary key being unique. Howwever, I do not think there can be such a strong penalty for indexes being UNIQUE. I side with David Raymond's opinion that SQLite would not search them twice when inserting a new row. That's merely opinion, though, since I have not read the source code. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
