On 30 Jul 2018, at 8:38pm, Gerlando Falauto <gerlando.fala...@gmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
