Re: SQLite3 - How to set page size?

2010-06-10 Thread durumdara
On jún. 10, 20:39, Ian Kelly wrote: > On Thu, Jun 10, 2010 at 12:25 PM, durumdara 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('VAC

Re: SQLite3 - How to set page size?

2010-06-10 Thread Ian Kelly
On Thu, Jun 10, 2010 at 12:25 PM, durumdara 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"

SQLite3 - How to set page size?

2010-06-10 Thread durumdara
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