Posted on September 23rd, 2011
Overseer generally maintains its own database and doesn’t bloat significantly larger than it needs to be to hold your data. However, in some limited situations, it may be beneficial to compact the database if it gets quite large for some reason. This function should be built into Overseer at a future time, but for now it can be done with this manual process:
- Download the Windows command line shell tool from http://www.sqlite.org/download.html (currently labeled ‘sqlite-shell-win32-x86-3070800.zip’, but that will change as new versions are released)
- Extract the contents of the above zip file to your c:\Program Files\Overseer 4\Data\ directory(assuming default paths)
- Make sure Overseer is closed
- Launch a command shell by going to Start->Run and typing ‘cmd’ and pressing enter.
- Type the following commands:
cd "\program files\overseer 4\data"
net stop overseersvc
sqlite3 overseer4config.db vacuum
sqlite3 overseer4data.db vacuum
- Now, you can close the command window and re-start Overseer, which will automatically prompt to restart the service.
If you have any questions or anything doesn’t go as described here, please contact support using the support link above.