ProgressUser732
New Member
Hello,
I have a progress open edge database and use the odbc openedge 10.1b drivers to connect and query the data.
When I use this driver, it usually takes 20 mins! to run a query with no joins that returns 5 to 10 results, why does it take so long?
What is the best driver to use?
Would learning 4GL/ABL query language speed up the query?
When I extract the same data to SQL Server and execute the query it takes 5 seconds.
How can I speed my query so that it takes the same time (or nearly the same time as SQL server does).
I am new to Progress Databases so any help would be appreciated.
Thanks.
I have a progress open edge database and use the odbc openedge 10.1b drivers to connect and query the data.
When I use this driver, it usually takes 20 mins! to run a query with no joins that returns 5 to 10 results, why does it take so long?
What is the best driver to use?
Would learning 4GL/ABL query language speed up the query?
When I extract the same data to SQL Server and execute the query it takes 5 seconds.
How can I speed my query so that it takes the same time (or nearly the same time as SQL server does).
I am new to Progress Databases so any help would be appreciated.
Thanks.