On Thu, Jun 10, 2010 at 12:25 PM, durumdara <durumd...@gmail.com> wrote: > Hi! > > I tried with this: > > import sqlite3 > pdb = sqlite3.connect("./copied4.sqlite") > pcur = pdb.cursor() > pcur.execute("PRAGMA page_size = 65536;") > pdb.commit() > pcur.execute('VACUUM;') > pdb.commit() > pcur.execute("PRAGMA page_size") > rec = pcur.fetchone() > print rec > pdb.close() > > But never I got bigger page size. > > What I do wrong?
According to the documentation, "The page size must be a power of two greater than or equal to 512 and less than or equal to SQLITE_MAX_PAGE_SIZE. The maximum value for SQLITE_MAX_PAGE_SIZE is 32768." Cheers, Ian -- http://mail.python.org/mailman/listinfo/python-list