SQLite3 - How to set page size?

[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 size.

What I do wrong?

Thanks:
dd

 

[Ian Kelly]

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

 

[durumdara]

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

Thanks! This was!!!

dd