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?

Top Replies

Chris Fleshood 4 months ago in reply to Zachary Hicks +1

At the end of the routine. Add a Stats/Off command, followed by a Stats/Transfer command, and you can send it wherever you like.

Parents

Zachary Hicks 4 months ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Zachary Hicks 4 months ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Chris Fleshood 4 months ago in reply to Zachary Hicks

Are you using the offline file via the Stats/On command?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Zachary Hicks 4 months ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Chris Fleshood 4 months ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Zachary Hicks 4 months ago in reply to Chris Fleshood

I guess for now I will just dedicate some portion of my day to changing over all programs to create an offline file. Do you know of a way to change the default location where it creates the offline file?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Chris Fleshood 4 months ago in reply to Zachary Hicks

At the end of the routine. Add a Stats/Off command, followed by a Stats/Transfer command, and you can send it wherever you like.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel