On Wed, 2005-02-02 at 15:15 -0500, Andrew Shakinovsky wrote: > >>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)? >
No It's slower. It has to keep track of the largest key that has ever existed in the table and that take a little extra time. -- D. Richard Hipp <[EMAIL PROTECTED]>
