On 3/16/18, R Smith <ryansmit...@gmail.com> wrote: > It's interesting to fathom what hypothesis is being tested with this pole...
INSERT operations on a table with AUTOINCREMENT do a full-table scan against the sqlite_sequence table. I'm wondering if it is worthing adding extra logic to do some kind of indexed lookup. For a schema with just a few AUTOINCREMENT tables, there is really no point in trying to use an index. But if you have hundreds of AUTOINCREMENT tables, some kind of index might be worthwhile. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
