Randem Systems Support Board

Ok, great.

I solved the problem by making two indexes on basic tables. Thanks for the answers.

So, is your question about Oracle or the RSdbControl? If it is using the control, post some code used to accomplish this task.

I don't understand the word code in this connection. Sorry, I'am a starter at Oracle.

What is the code you are using for this?

I am using sql plus. The datbase server is located in our head office. We have a dedicated line SDSL 1024/1024 Kb 1:2

htimmerman,
 
Please elaborate, I imagine you are using the RSdbControl dll? How are you connected to Oracle? Where is the server located? What kind of connection are you using? Is the connection accross the internet? Etc, Etc...

I have created nested views three levels deep in Oracle 8i. The performance of the query on the top view is very poor. How do I get a better perfromance?

Guest,
 
For Oracle use the type that matches the driver you have installed. If you have an OLEDB or ODBC driver installed use the appropiate connection.
 
Most Oracle users have ODBC connections, but a DSN less (OLEDB) connection would fare better if available.
 
This was in the wrong section so it was moved.
 
BTW: Oracle is listed oin the documentation

I have downloaded the rsdbcontrol and tested it with the access2000 database. But not clear as to how to connect to oracle using this. The code gives some examples like Access, mysql etc. But oracle is not given. Please help.