Hello,
I have an issue with my database (sqlite 3.4.2), runing some updates
makes it use more filespace than needed.
I am using this kind of schema :
CREATE TABLE mytable (myKey TEXT PRIMARY KEY, myInt INTEGER, myBlob
TEXT)
1st : Inserting a row
Let's say that myBlob data is 256K. After the insert, everything is
fine, the database is slighly more than 256K.
2nd : Updating myInt in the freshly inserted row
UPDATE myTable SET myInt=1 WHERE myKey=1
After the update, the database size will double. I can now repeat as
many updates as I want on that row, the database won't grow anymore.
(Note that vacuuming the database makes it regain its normal size, but I
want to avoid running some vacuum since the database can be huge.)
Is it a normal behavior ? Something I am doing wrong ?
Any help would be really very appreciated.
Thanks for your attention
--
_ _ __ ____ __________________ ___ __ _ _
Jean Collonville
web : http://www.hungmaow.org
jabber : [EMAIL PROTECTED]
PGP Key : http://www.hungmaow.org/cjean.asc
signature.asc
Description: This is a digitally signed message part
