On 6 Jan 2018, at 8:42pm, Dinu <dinumar...@gmail.com> wrote:
> Richard Hipp-3 wrote
>> all the parent b-tree pages must be updated
> Yup, no question about it, at best it could be an opt-in. But as it is a
> design decision, I checked to make sure count() really is O(n) as Jonathan's
> question implied.
It would be possible instead just to keep a count of the total number of rows
in each table. The count could be kept with the table header, or in a new
column of the table structure as the current autoincrement counter
Just like the discussion up to this point, it would be very difficult to figure
out, for the average user, whether doing this either way would make things
significantly faster or slower.
sqlite-users mailing list