Currently I?m working with an AS400 mod 2.4 and Visual Basic 6.0 to create a Graphical User Interface (GUI).
Early into the development phase of the project I encountered result set retrieval performance issues. To take advantage of Active X ?s Data Object (ADO) high speed and low memory overhead to access a database. The VB Data Form Wizard s is used to create the form. It takes 30.49 seconds to retrieve a 179 record set. This data retrieval time should be considerably lower. Can you assist?
