hexagon logo
Register Sign in
  • Replies 12 replies
  • Subscribers 10 subscribers
  • Views 257 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

  • I am having the same, if not very similar, issue with Datapage+. My CMM program runtimes are 3-4 times longer when ran with stats on (a program that normally runs 20 mins could take an hour or longer, my 1 hour programs now take 3-4 hours). Can someone explain how to setup this special schema on the database side? I am trying to avoid having to change to an external command if I can help it. 

  • in reply to Zachary Hicks

    Are you using the offline file via the Stats/On command?

  • in reply to Chris Fleshood

    No, we use online connection. My predecessor setup all of the programs with an online connection to DataPage. I have tested a couple programs with swapping to an offline file and having the Data Importer sweep the files into the database. It does work and does not slow down the programs, but for the same reason I don't want to swap to an external command (we have thousands of programs I would have to update) I would prefer to setup a schema on the database to help fix the connection. I just don't know how to do that yet. 

  • in reply to Zachary Hicks

    Yeah that would be the problem.  That function of the Stats/On database direct connection command hasn't really had much support in a long time as we switched to the offline file method a long time ago.  Let me also recommend if you ever switch, do not use the External Command, just check the box for the Offline in the Stats/On command.

Reply
  • in reply to Zachary Hicks

    Yeah that would be the problem.  That function of the Stats/On database direct connection command hasn't really had much support in a long time as we switched to the offline file method a long time ago.  Let me also recommend if you ever switch, do not use the External Command, just check the box for the Offline in the Stats/On command.

Children
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement