Dear Simon and Dan,
thanks for your valuable information, which we were looking for.
Kind regards
Alex
______________________________________________________________
Od: "Simon Slavin"
Komu: General Discussion of SQLite Database
Datum: 21.01.2012 12:49
Předmět: Re: [sqlite] Another 3.7.10 question
On 21 Jan 2012, at 8:28am, Dan Kennedy wrote:
You can get the old behavior by issuing a statement like:
PRAGMA page_size = 1024;
When creating the database.
Alternatively, if that data is now fixed and you care about the filesize, do a
VACUUM
and see if that shrinks the database in a way you like.
The actual underlying file format hasn't changed, just the way the functions
fill the file. You can swap back and forth between 3.7.x versions and they'll
still all be able to read and write the file.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
