mainly just want to summarize and get confirmation on a few points.

1.       matching pagesize to file system record size is recommended for write 
performance improvements

2.       default SQLite pagesize is 1k; max SQLite pagesize is 32k

3.       docs seem to say that 32k max pagesize is no longer required, i.e. 
could possibly compile w/ larger max pagesize (and thus larger pagesize)

4.       larger pagesize will cause more data to be read from file system to do 
a read (i.e. an entire page must be read)

thanks
tom

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to