On 9 Dec 2015, at 9:10pm, David Baird <dhbaird at gmail.com> wrote: > My cocnern is that: the database engine shouldn't > needlessly waste/discard perectly good chunks of rowids
Please don't think of them as 'chunks'. There is no order to the numbers it picks. An alternative way to think of the AUTOINCREMENT mechanism is that it simply picks a random number, checks to see that it's not already in use, and returns that. You shouldn't depend on anything 'sequency' about the rowids it creates. If your program depends on them being a sequence, generate the numbers you want yourself, in the sequence you want. Simon.
