SQL Report of current installed version VS most recent version


1 comment

  • Andy Langton

    Update, I think I figured out the issue, unfortunately there is no easy way  to do what I want it seems like.


    The issue is that the ~Applications table in the PDQ Inventory database stores the computerID field as text instead of an integer, so when doing the queries above it is trying to do the join on text rather than an integer which is much slower.


    To test this, I created a new table called ~Applications2, but made the ComputerID column an integer instead of a text field, and then selected all of the contents of the ~Applications table into it.  After doing this, the query that took a very long time before completed in 400ms.

    Comment actions Permalink

Please sign in to leave a comment.