>>With just INTEGER PRIMARY KEY, if you delete the largest >>key in the table then insert a new row with a NULL key, >>the key that was deleted will get reused. If you add >>AUTOINCREMENT, keys will never be reused this way. The value >>inserted will be one more than the largest key >>that has ever been in the table since the table was >>first created. >>-- >>D. Richard Hipp <[EMAIL PROTECTED]>
Is AUTOINCREMENT more efficient (for speed)?
