Is the record size you refer to here the same as the "Average payload per entry" that sqlite3_analyzer determines for me?
On Wed, Feb 23, 2011 at 5:09 AM, Max Vlasov <max.vla...@gmail.com> wrote: > Greg, you should also take the record size into account. My hypothesis is > that if your record is comparatively small (several fits into 1024) the > speed of select count will be the same for any page size (my quick tests > confirm this). It's interesting to know what is an average size of your > record to understand why the numbers are so different. > > Max > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users