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!).

Reply via email to