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

Reply via email to