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.