Database

Top  Previous  Next

PDQ Inventory stores all of its data in a SQLite 3 database file located at %ProgramData%\Admin Arsenal\PDQ Inventory\Database.db.  %ProgramData% is usually either C:\ProgramData or C:\Documents and Settings\All Users\AppData (depending on the version of Windows).

This file can be accessed using any tool that support SQLite 3 files (version 3.7 or later). The structure of the data will change over time as new features are added or changed, so please keep this in mind if you are going to access the data directly.

Optimizing

The database file will fragment over time and should be optimized periodically to ensure peak performance.  Optimizing can be done either in the Database Preferences or on the Command Line.

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 it to complete.

See Also

Data Files
ODBC How-To