asked on
Connecting to Progress
I have a report server that is MSSQL 2008. I get data from an ERP system that is Progress 9.1x. Currently, I connect through an ODBC and pull data over with OpenQuery. This works fine with one exception.
Under load when users are banging away at the ERP, the import slows to a crawl and slow Progress down on some queries. The table I'm hitting has close to a million records. We have put indexes on the table and select only specific records, passing the conditions through OpenQuery.
I'm thinking there has to be a faster way to connect to Progress. The same query using the Progress SQL tool are super fast. That leads me to think the bottleneck is ODBC. On off-peak hours, my queries run within a minute or two. During the day, they take 20-30 minutes.
The question is: Are there more modern methods to connect to Progress than ODBC?
Under load when users are banging away at the ERP, the import slows to a crawl and slow Progress down on some queries. The table I'm hitting has close to a million records. We have put indexes on the table and select only specific records, passing the conditions through OpenQuery.
I'm thinking there has to be a faster way to connect to Progress. The same query using the Progress SQL tool are super fast. That leads me to think the bottleneck is ODBC. On off-peak hours, my queries run within a minute or two. During the day, they take 20-30 minutes.
The question is: Are there more modern methods to connect to Progress than ODBC?
DatabasesMicrosoft SQL Server
Last Comment
dlauzon
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Upon further review, the answer is to rev up an application server. I'm new to this, but it seems that this is an API for quickly getting Progress data.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.