On 03/13/2015 09:30 PM, Alexandre Mainville wrote: > Hi, > > When using the zipvfs extension, one can change the size for the upper > pager using pragma page_size but how does one change the page size for the > lower level pager. The zipvfs_block_size pragma does not seem to support > setting the value.
Enable URI filenames: https://www.sqlite.org/uri.html and specify an option of the form "block_size=N". The lower level pager should use a page-size of N bytes to access the database file. e.g. file:test.db?block_size=4096 The setting is not persistent - each client should specify the block_size=N option separately. Dan. > > Thanks > > Alex > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users