On 3/16/18, R Smith <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
