Prognosis to ODBC doing select count(*) every 2-3 minutes

[HenryH]

(Copying information from my Community post)

Hello,

We've configured Prognosis to output through ODBC into SQL Server for our Base24-eps data.

Recently our DBA pointed out that this query is performed every 2-3 minutes all day and it's a pretty high impact on the server.

Can you tell me why this query is running every 2-3 minutes and is there a way to supress it?

SELECT COUNT(*)

FROM IR_B24EPS

Thanks,

Henry

[Scot_Clark]

Hello Henry,

Not sure of the details of the process.  It sounds like you are summarizing from a prognosis database to the MS SQL database.  If so the frequency can be controlled by the database summary properties on the configuration tab.   let me know  if this help or if there is something different set up.