Reference > Preferences >

Database

Details and tools for the PDQ Deploy database.

SQLite Console

Open the database in a text console allowing direct access using SQL.  For more information on the SQL language visit SQLite documentation.

Optimize

Rebuilds the database by reorganizing the data and indexes.  The database will get fragmented over time and an optimization should be done periodically in order to keep the database running at top performance.

An optimization works best when there are no other programs accessing the database.  The optimization will still work, but it may cause other processes to timeout waiting for it to complete.

Note  Running Optimize will stop the Background Service and close the PDQ Deploy console.

PDQ Deploy Version 5 (Release 2) © 2015 Admin Arsenal