On 5 Dec 2019, at 6:31pm, Zhu, Liang [AUTOSOL/ASSY/US] <[email protected]>
wrote:
> If I do not do Vacuum, my database size just keep raising, eventually the
> database size gets to over 90% of storage size, I can save data to the
> database any more.
VACUUM should not be saving you any space. And VACUUM puts a lot of traffic
through your storage device which will eventually kill it.
What journal mode are you using ? In other words, what does the command
PRAGMA journal_mode
output ?
Does your application close the connection correctly ? In other words, do you
call sqlite3_close() or sqlite3_close_v2() and check the result code it returns
?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
