SQLite3 - How to set page size?

durumdara durumdara at gmail.com
Thu Jun 10 14:25:01 EDT 2010


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?

Thanks:
   dd



More information about the Python-list mailing list