> Interesting. But, with the above suggestion, every INSERT or DELETE > would slow down anyway as much as it would have were SQLite to maintain > meta information itself, no? > > ..... > > Hence, it might be worthwhile maintaining the meta information no > matter what... most of the folks won't ever notice it, and everyone > would marvel at how quickly COUNT(*) was returning the results.
I cannot say I have ever used COUNT(*) in any program I have ever created I can say however, I tend to use INSERTS fairly often IMHO, not maintining the meta info (which speeds up a process everyone does at the expense of speed in a process less people do) seems like the correct decision
