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 <https://sqlite.org/fileformat2.html#seqtab> 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users