I have created a table in my Oracle database and am trying to add / edit / delete/ query the records. This table already has 4000000 records. Now when I try to query the database, it takes close to 3 minuetes to return records. I have tried creating indexes, but was not successfull so far.
Following is the structure:
User : varchar(20)
Fac : varchar(10)
I am using the following code in VS2005:
I am not sure why the following code takes over 3 mins to execute. Even if I enter an Insert or Update statement, it takes close to 40 seconds to complete. I have created indexes on fac, userid, prm but none of them seem to improve performance.
Could someone help me with this please? I am at a total loss. Any help is greatly appreciated.
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim myReader As OleDbDataReader
Dim strConnString as String = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=acds;Password=acds;Data Source=entp"
myConnection = New OleDbConnection(strConnString)
If myConnection.State = ConnectionState.Closed Then
Dim sSql As String
View Complete Post