Visual BASIC using ADO with Progress - Slow Performance

P

PKFIOM

New Member
I am trying to use Visual Basic 6 with ADO to extract data from a Progress database.

I can successfully read the required data from the database but the performance is poor - it is taking 30 seconds to display a single column from a single table into a list box (3200 records in table)

Is there anything that can be done to speed up this access time - either on the client or server side

FYI - Server Side : Progress 9.1d running on Windows 2000 Server , EXE of the Visual Basic Application runs off this server

Client Side : Merant ODBC (v3.60 SQL92 v9.1d) - installed via Progress 9.1d client instalaltion

All the network runs on gigabit and I have no other networking issues
 
Upgrading Progress to 9.1E (or better yet OpenEdge 10.1) and getting the DataDirect ODBC drivers would be a good start.

Beyond that it may just be a generic query or database tuning problem. Or it could be something else (did you say Windows 2000 Server?)
 
Unfortuantely the Progress system I am extracting the data from has been written by a third party - they have no immediate plans to go to OpenEdge v10 - so I am stuck with 9.1d for now

I am fairly confident that the underlying network infrastructure is sound

I have seen reference to the Data Direct ODBC drivers before - which version of this product do I need and should this go on the client side, server side or both
 
There are knowledge center articles on both Progress' and DataDirect's web sites that can tell you more specifically than I can but, as I recall, somewhere around 9.1d05 DataDirect became the preferred ODBC driver.

If you're stuck running version 9 you really, really ought to be running at least 9.1d07 and ideally 9.1e04 (which is the final service pack for version 9). Plain vanilla 9.1d is a) ancient b) buggy and c) slow.
 
You must log in or register to reply here.
Back
Top