>hi, i am a problem
>
>I connect with ODBC to Oracle8i over S.O. Unixware, but with a table of 60 records the computer es very slowly (2 minutes or more)
>
>What happened with it?, is a lie that to access quickly with ODBC drivers?
>
>may I help You?
>
>
>rnovoa@yupi.com
>
>Alberto
Pipo,
I am experimenting with ODBC connections to Oracle8i.
I had a test table with 9,500 records. My form would display the first record in under a second. (P450 with 128MB RAM). However, the dynaset which was used is sparsely populated. If I click the button to go the the last record it could take 10 or 15 seconds for that record to display. It is the same if I opened a browse window in a datasession. The first grid full of records displays very quickly but going to the last row will take some time. If the table were 1,000,000 records it could take a *lot* of time! That is why I am switching to using stored procedures and communicating via *.PARAMETERS.ADD() and *.PARAMETERS() functions, then refreshing a small subset of data with a dynaset in order to populate forms.
JLK
gc_SQL_Statement = ''
go_OraSession = CREATEOBJECT("OracleInProcServer.XOraSession")
go_OraSession.LastServerErrReset
go_OraDatabase = go_OraSession.OpenDatabase('orc2','rev0205/rev0205',0)
IF go_OraSession.LastServerErr <> 0
=MESSAGEBOX("Error: "+STR(go_OraSession.LastServerErr))
THISFORM.cmdClose.CLICK()
ENDIF
go_OraDatabase.LastServerErrReset
gc_SQL_Statement = "SELECT * FROM INDIVADR ORDER BY INDIVKEY"
go_OraDynaSet = go_OraDatabase.CreateDynaset(gc_SQL_Statement,0)
IF go_OraDatabase.LastServerErr <> 0
=MESSAGEBOX("Error creating OraDynaset")
THISFORM.cmdClose.CLICK()
ENDIF
go_OraDynaSet.MoveFirst
Nebraska Dept of Revenue