Speed

[Lynn]

Hi, I'm using ADODC and RDODC to bind my tables with a database, but it's taking a lot of time to open the desired records, why is it so? Are there better alternatives? Thanks in advance.
Lynn

[Aaron Young]

Try using the Objects (References) rather than the Controls. The Controls are designed to give you a nice black box which is easy to use, but in so doing there is alot of background activity and references you don't neccessarily need, but slow you down.

Using the RDO Objects you can also specify the Type of Cursors to create, setting this to rdNoCursors creates lightening fast Read Only Resultsets.


Aaron Young
Analyst Programmer
[email protected]
[email protected]