dboulden
New Member
Hi,
I'm a veteran ColdFusion developer, but completely new to Progress. I'm creating a web based system to retrieve info from a Progress v8.3B database using ColdFusionMX. I'm using the DataDirect (Merant) v3.7 ODBC driver to connect to the Progress datbase on a SCO Unix box, CF is installed on a Win2K machine using IIS web server. It all connects OK, and I'm getting data back, but it is horrendously slow (> 5 mins) when it should be near instantaneous. Are there any special requirements to be aware of when formulating the SQL calls that differs from the normal SQL servers? The type of call I'm doing is
SELECT name, address, postcode FROM account WHERE name LIKE "ABC%"
thanks in advance!
Dave Boulden.
I'm a veteran ColdFusion developer, but completely new to Progress. I'm creating a web based system to retrieve info from a Progress v8.3B database using ColdFusionMX. I'm using the DataDirect (Merant) v3.7 ODBC driver to connect to the Progress datbase on a SCO Unix box, CF is installed on a Win2K machine using IIS web server. It all connects OK, and I'm getting data back, but it is horrendously slow (> 5 mins) when it should be near instantaneous. Are there any special requirements to be aware of when formulating the SQL calls that differs from the normal SQL servers? The type of call I'm doing is
SELECT name, address, postcode FROM account WHERE name LIKE "ABC%"
thanks in advance!
Dave Boulden.