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


  • 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.
Reply


  • 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.
Children
No Data