Hi All,

I'm using sqlite 3.6.7 on an embedded platform and I have a table with 3
columns [INT, TEXT, INT],  SQLITE_DEFAULT_PAGE_SIZE=1024, i'm trying
to inserting text of more than 2K characters, so when large number of
inserts and deletes happen, after some time due to fragmentation I simulated
VACUUM (like insert all the records to another fresh database), while doing
this operation, got an error saying "disk image malformed".
But with the increase of SQLITE_DEFAULT_PAGE_SIZE=4196, the error
eliminated.
So how is PAGE SIZE impacting in this scenario.?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to