Jump to content

How to Compact database and reclaim disk space?


spongebob
 Share

Recommended Posts

Our Delegate database is close to 1gb in size. Over the past few months we have deleted a lot of data via the delegate web interface. How do I reclaim the space on the drive? I have thought about creating a new db and transferring the data over via options menu. Alternative is running sqlite3 and running a sql "vacuum" command. What is the recommended way to reclaim the lost space?

Link to comment
Share on other sites

Our Delegate database is close to 1gb in size. Over the past few months we have deleted a lot of data via the delegate web interface. How do I reclaim the space on the drive? I have thought about creating a new db and transferring the data over via options menu. Alternative is running sqlite3 and running a sql "vacuum" command. What is the recommended way to reclaim the lost space?

Delegate doesn't have a way to compress the active database (use the "Send Improvement Suggestion or Feedback" menu item to put an official request in if you'd like to see that), so the "Copy data to new database" button is probably your best bet, if you have the space.

 

The SQLite method might work, but I wouldn't recommend it.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...