Is PDQ Inventory Running Slowly? Some Tips To Speed It Up.

Follow

Comments

5 comments

  • Shapiro, Jonathan

    Very informative.  Is there a way to combine these commands into a script that would first stop the service, then launch SQLite and execute the commands and finally restart the service?

    0
    Comment actions Permalink
  • Adam Ruth

    Jonathan, certainly.  This will work for Windows 7 64-bit, just change the environment variables to get it to work on other systems.

    set sqlite="%ProgramFiles(x86)%\Admin Arsenal\PDQ Inventory\sqlite3"

    set database="%ProgramData%\Admin Arsenal\PDQ Inventory\Database.db"

    net stop PDQInventory

    %sqlite% %database% "delete from ComputerScans;"

    %sqlite% %database% "vacuum;"

    net start PDQInventory

    0
    Comment actions Permalink
  • Adam Ruth

    Just to note, we're going to add in an automatic vacuum in the next version of PDQ Inventory, to make it so you don't need to do it manually.

    0
    Comment actions Permalink
  • Andrew Jackson

    This absolutely helped me. I also recently moved the database to faster drives, and it made a huge improvement.

    0
    Comment actions Permalink
  • Sebastien Faterl

    Hello, 

    i'm testing actually your solution. 

    each time i do an action i'm facing some bigs Slowings down on pdqDeploy and inventory nut more in deploy)

     

    I did exactly what is explained above, and i desactivated the windows firewall and mc afee scanning and acces folders (for programdata\admin arsenal and programfiles\admin arsenal.

    Installed on a Virtual Machine with two processors with two cores with 8Go RAM...

    Everything is configured to well 

     

    Please HELP

     

    Thank You

     

    0
    Comment actions Permalink

Article is closed for comments.