On Dec 9, 2015 7:14 PM, "Simon Slavin" <slavins at bigfraud.org> wrote: > > > 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. >
Yes, I am aware. Note that the application is correct as it doesn't care about rowid 'sequenceyness'- but that's not what the OP is about at all. The OP was concerning a minor technical issue regarding the implementation details of SQLite. All other points, I agree with, but they're moot anyways because this isn't about application correctness (the application is already happily correct!).