Hi, At the moment the sqlite_sequence table: * doesn't exist when a database is first created * is created when an AUTOINCREMENT table is created * doesn't use a primary key on the name column * doesn't get populated with the sequence row for a table until a row is added to the table.
Would adding a primary key definition to the sqlite_sequence table cause a performance problem? If there are many tables using autoincrement then surely it would help. Additionally, if it had a PK defined then it would be possible to update this table using INSERT OR REPLACE... Failing that, or in addition to that, populating the table with the sequence row for the table at the same time as the autoincrement table is created would be nice. Regards, Brodie ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------