A side note about VACUUM:
If I remember correctly, tables which do not have INTEGER PRIMARY KEY will have
their rowid column reassigned. Be careful if you are using rowid.
Roman
________________________________
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of
Simon Slavin <slav...@bigfraud.org>
Sent: Thursday, December 5, 2019 2:03 PM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] [EXTERNAL] Re: what is the optimized way to do the vaccum?
CAUTION: This email comes from an external source; the attachments and/or links
may compromise our secure environment. Do not open or click on suspicious
emails. Please click on the “Phish Alert” button on the top right of the
Outlook dashboard to report any suspicious emails.
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://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailinglists.sqlite.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsqlite-users&data=02%7C01%7Croman.fleysher%40einsteinmed.org%7C150f6e61d5e047dfe37e08d779b73fd1%7C9c01f0fd65e040c089a82dfd51e62025%7C0%7C0%7C637111700322791016&sdata=x6sIZJFg33wns0NYU67N7cIyE%2FZsBC3N6Yp6P%2FuRFLo%3D&reserved=0
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
