DataPage+ 5.0

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • DataPage+ 5.0

    Reaching out as I'm currently looking for a workaround regarding large amounts of data.

    We have close to 40 CMMs here running 24/7 and STATS ON/OFF'ing into a database on a SQL Server. It's been a couple weeks since a project was implemented at one of our remote facilities and I've stumbled across a problem. This query is coming out of PCDMIS as these programs run and is taking a very long time to complete,

    SELECT "Transaction_SID","Variable_SID","Data_Value","Exc lude" FROM "Transaction_Data"

    There are currently 903995 records in that table and it's rapidly increasing. Every time a part is ran with STATS ON/OFF it is running this query - which is adding around ~15 seconds to complete. This will only get worse as more records are added. The funny thing is I can't see a reason to return Every value ever entered into this table.

    Has anyone run across something like this before and if so how have you handled this?

  • #2
    Originally posted by Capa! View Post
    Reaching out as I'm currently looking for a workaround regarding large amounts of data.

    We have close to 40 CMMs here running 24/7 and STATS ON/OFF'ing into a database on a SQL Server. It's been a couple weeks since a project was implemented at one of our remote facilities and I've stumbled across a problem. This query is coming out of PCDMIS as these programs run and is taking a very long time to complete,

    SELECT "Transaction_SID","Variable_SID","Data_Value", "Exc lude" FROM "Transaction_Data"

    There are currently 903995 records in that table and it's rapidly increasing. Every time a part is ran with STATS ON/OFF it is running this query - which is adding around ~15 seconds to complete. This will only get worse as more records are added. The funny thing is I can't see a reason to return Every value ever entered into this table.

    Has anyone run across something like this before and if so how have you handled this?
    Can you edit the Query?

    If so adding a WHERE clause can drastically speed that up.

    Why would Pc-Dmis be query-ing something? Is this something custom?
    Last edited by Kp61dude!; 03-21-2019, 04:05 PM.
    PcDmis 2015.1 SP10 CAD++
    Global 7-10-7 DC800S

    Comment


    • #3
      No. It's PCDMIS's STATS command that is running this (I think). The SPID's program name field has "Hexagon Manufacturing Intelligence " as its value.

      These SPID's are also originating from the computers at the CMM machines. It's all newly setup and the only thing interacting with the database is PCDMIS via STATS ON/OFF.

      Comment


      • #4
        We used to have issues with stats on/off taking to long to send data. We switched to a external command like this....
        EXTERNALCOMMAND/NO_DISPLAY, NO_WAIT ; C:\PROGRAM FILES (X86)\HEXAGON\DATAPAGE+ 5.2\DATAPAGESTATS.EXE -L
        Adding the -L to the end means its listening and gathering info as the prg runs, so when its done, the file is already built and ready to send to datapage. Maybe this will work for you?

        Comment


        • #5
          Just an update.

          @2013_junkie
          Yeah one of the CMM guys mentioned something about this. It's my backup plan ATM as it will require us to touch all the programs either by hand or via COM PCDLRN. Thanks for the info.

          Right now I've set up a special schema on the database side that we're applying to CMM's users only. It has a view on it with the same name (Transaction_Data) and limits the select via a "TOP 1". This means that those queries are only returning one row at the CMMs when this query runs - which is pretty regularly. We've been testing to make sure nothing was broken by doing this and everything has looked positive so far. It is kind of insane that STATS ON/OFF queries the entirety of Transaction_Data.

          Comment


          • #6
            Originally posted by Capa! View Post
            STATS ON/OFF queries the entirety of Transaction_Data.
            Why does it query? It's 'uploading' data from a finished routine run, right? If so that is weird.

            PcDmis 2015.1 SP10 CAD++
            Global 7-10-7 DC800S

            Comment


            • #7
              Originally posted by Kp61dude! View Post

              Why does it query? It's 'uploading' data from a finished routine run, right? If so that is weird.
              This is exactly why I'm posting here. It doesn't make sense. Limiting that query doesn't affect the output over to the database as far as we've tested so I have no clue what it's doing with all that information. This query is coming from a ton of different versions of PCDMIS as well, including 2018 R2.

              Comment

              Related Topics

              Collapse

              Working...
              X