Note sure. Will get back on this as soon as I have played a bit with the
analyzer utility!
What I meant was "My own estimated x bytes/row" :)
x + ID + ~20 characters should make some ~32 bytes :)
> Date: Wed, 23 Feb 2011 10:58:00 -0800
> From: fle...@fletchowns.net
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] COUNT() extremely slow first time!
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
