SQL Server, Linked DB, Performance

B

BCM

Member
We have an application built with Progress 9.1D. The Progress database sits on a Windows 2000 server. We also have MS SQL Server databases. From MS SQL Server we have added the Progress database as a Linked Server. We use DataDirect 4.1 as the ODBC driver.

In the Progress database is a table named "Contract". The Progress database has an index on the contract table with two columns defined as index keys: "contract-no" and "ar-entity".

When I issue the query, below, from MS Query Analyzer the first execution takes over 45 seconds. Subsequent executions for the same key values run in 1 second. What can I do to make the first execution run as quickly as subsequent executions?

select "booked-date"
from DEV.."PUB"."CONTRACT"
where "contract-no" = '22001' and "ar-entity" = '01'


Thank-you,
Brian
 
OK, I can now answer my own question. The longer execution time on the first SELECT was due to SQL Server determining the execution plan. The better approach is to use OpenQuery() to pass-thru the SQL statement to Progress.
 
You must log in or register to reply here.
Back
Top