Yes, Greg, please post this value for this table you use in count query Max
On Wed, Feb 23, 2011 at 9:58 PM, Greg Barker <fle...@fletchowns.net> wrote: > 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