-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Make a new db-file in the windows explorer.
> Open this file in the console with sqlite3 db-file.
> Then set the page_size and the cache_size with the pragma statements.
You cannot change the page size of a database after it is created(*). When
you call sqlite3_open and the file doesn't exist then a zero length file is
created (to verify you can). SQLite doesn't write anything to the file
until you create some data. So the steps are really simple:
sqlite3_open("filename") -- creates zero length file
exec("pragma page_size=xxx") -- sets page size to user
exec("create table foo(a,b,c)") -- actually writes something to file
(*) You can however back it up to a database with a different page size and
I believe you can do something with vacuum too.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkrMTwkACgkQmOOfHg372QRWGQCfV8+VrloH3vSyDZ046Io01yjY
RRgAoK/SrLoNFRIAxUQzrbSVQy5mW6Ge
=awOq
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
