I am trying to perform a simple count on Progress tables using SQL through ODBC from SQL Server. This is taking and age and often times out waiting for progress to return. I am having a particular problem with a table that currently contains 2.5m+ rows.
I have tried returning all the rows and doing the count on the SQL Server side. This does improve the time dramatically but still takes to long.
FROM OpenQuery(<LinkedServer>,'SELECT 1 FROM <BigTable>')
Is there a progress funtion or table that contains this information in progress that I can use?
I would be very grateful if anyone could offer some advice.