RadiAnt DICOM Viewer - Discussion Forum
optimize database

Jun 10, 2020 03:31 PM
by Tommy
what's exactly the function of that submenu item?
Jun 10, 2020 07:50 PM
by boskar
sqlite VACUUM?
Jun 13, 2020 10:53 AM
by RadiAnt
Exactly, this is the VACUUM command.
"The VACUUM command rebuilds the database file, repacking it into a minimal amount of disk space."
Jun 25, 2020 12:55 PM
by Tommy
when should I use it? is there any specific scenario I should push that button?
Jun 25, 2020 02:59 PM
by boskar
After importing and removing a few dozens, maybe hundreds studies to and from Radiant the database file can grow (occupy too much space) and become slow due to unused data being kept (just the metadata, actual pictures are removed).
It would be a waste of time to remove them and shrink the database after removal of each individual entry, therefore those data are kept until overwritten by new study or until VACUUM is performed.
Invoking it more often then once a week/month is totally unreasonable. It makes sense if You want to copy the entire database to pendrive, You would get rid of unused data.
Jun 27, 2020 09:09 AM
by Tommy
thanks for the clear explanation
Post reply
Author (first name or pseudonym):

Message:

You have to accept cookies to be able to post messages.
Visitors can post messages on the forum without having to register. Please input your first name or pseudonym in the "Author" field. Do not publish any personally identifiable information (PII).

Please ensure you write your posts in English so that our international audience can understand and reply to your message.

The Administrator reserves the right to remove any messages that violate our forum rules; for example, those that are not related to the RadiAnt DICOM Viewer software, published in a language other than English, contravene regulations, etc.