Tortoise

[Lynn]

Could anyone help me with my code? My program is running at a very slow speed in retrieving data from the Oracle server. I have tried to create indexes to try to improve its slowness but to no avail. Part of the code that is causing the problem is as shown:

Private env as rdoEnvironment
Private cn as rdoConnection

Private Form_Load()

Dim Sqlcon, Sqlrs as String
Dim rs as rdoResultset

SqlCon = "Provider=MSDAORA.1;DSN=orc0;UID=pssd;PWD=GHFD"

set cn = env.openConnection("orc0",rdDriverComplete,False,Sqlcon)

Sqlrs ="Select * from af_Table where column1 ='" & text1.text & "'"

set rs = cn.openResultset (Sqlrs, rdOpenKeyset, rdConcurValues)

End Sub

[Rob HErmans]

Try changing the "select *" to "select field1,fields2 etc" using the specific field names. I am using ado with jet and the * was causing my retrieval times to poor. Has really sped up now that I use the specific fields
Hope this helps
Rob