hexagon logo

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","Exclude" 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?
Parents
  • 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.
Reply
  • 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.
Children
No Data