On Fri, Aug 20, 2010 at 12:27 AM, Taras Glek <[email protected]> wrote:
> Hi, > I really appreciate that sqlite got this feature to reduce > fragmentation, but why not expose this as a pragma? > Taras, I think that you're overestimating the feature. On the OS level it won't matter how far the file pointer will go, a larger block still can be fragmented if the OS don't find a continuous block. On the sqlite pager level it's the same, for identical appends your data will probably get the same pages in the file regardless of the chunk size. I suppose it has some benefits in some specific cases and if it gets its own pragma it will just add confusion. Max _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
