On Mon, Jul 30, 2018 at 9:42 PM, David Raymond <david.raym...@tomtom.com> wrote:
> Doesn't sound quite right to me. > > No matter the index you have to search through it to find the spot to do > the insert. Both are going to do that search only once. An insert on a > unique index isn't going to search through it for existence, then promptly > forget what it just did and do it all over again to do the insert. It's > going to start the insert and find the spot where the new item would go. If > the spot's free it succeeds, if it's taken then it fails. There is no need > for a second search. > > Hence my original question: why would a Unique Index be any worse? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users