We are using Journal_mode=delete, sqlite3_close().
Liang
-----Original Message-----
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of
Simon Slavin
Sent: Thursday, December 5, 2019 2:04 PM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] [EXTERNAL] Re: what is the optimized way to do the vaccum?
On 5 Dec 2019, at 6:31pm, Zhu, Liang [AUTOSOL/ASSY/US] <liang....@emerson.com>
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
sqlite-users@mailinglists.sqlite.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=jOURTkCZzT8tVB5xPEYIm3YJGoxoTaQsQPzPKJGaWbo&r=4Y1ZhFy9bpH-wvkl_u5WMmphQqcZcyyY0DFEINZ4E6I&m=QYaDMvjAXTSup0wv5mZP9nCIDsvmUkbkTWuYAtrJ6l8&s=Z4Qe515HCPlNxogmpfk3Z2O67uL7Hi9ifp1EmpU7oIg&e=
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
