hexagon logo
Register Sign in
  • Replies 12 replies
  • Subscribers 10 subscribers
  • Views 326 views
  • Users 0 members are here
Options
Related

DataPage+ 5.0

Capa!
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
  • 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?
Reply
  • 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?
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement