In my web page I have written code that writes to a table in Oracle 9i. What I find is add ing or querying the table in Oracle is very slow. I tried doing the same with SQL server database and the process if 5 times faster than Oracle. In the Oracle or
SQL table I have not created any indexes / primary keys, but still I find the SQL is way faster than Oracle. Is there any way that I could improve the speed in Oracle?
My table has 3 columns (PRVal, FACVal and UserID). And when the user is selected from the web page I retreive the values from the database, using a direct sql (no pl/sql stuff here, as I am new to Oracle). I use OleDBConnection, OleDbCommand and OleDbReaders
classes to access Oracle data.
OLEDb always has a performance hit...there are reasons behind it.
Better use the .Net oracle provider (ODP.Net). The Oracle Data Provider for .NET (ODP.NET) is Oracle's high performance ADO.NET 2.0 compliant data provider.
Member
9 Points
398 Posts
Add / Retrieve is slow in Oracle
Jul 15, 2010 01:44 PM|coolvaas1|LINK
In my web page I have written code that writes to a table in Oracle 9i. What I find is add ing or querying the table in Oracle is very slow. I tried doing the same with SQL server database and the process if 5 times faster than Oracle. In the Oracle or SQL table I have not created any indexes / primary keys, but still I find the SQL is way faster than Oracle. Is there any way that I could improve the speed in Oracle?
My table has 3 columns (PRVal, FACVal and UserID). And when the user is selected from the web page I retreive the values from the database, using a direct sql (no pl/sql stuff here, as I am new to Oracle). I use OleDBConnection, OleDbCommand and OleDbReaders classes to access Oracle data.
Any help is greatly appreciated.
Contributor
2902 Points
705 Posts
Re: Add / Retrieve is slow in Oracle
Jul 16, 2010 01:30 AM|PassHours|LINK
OLEDb always has a performance hit...there are reasons behind it.
Better use the .Net oracle provider (ODP.Net). The Oracle Data Provider for .NET (ODP.NET) is Oracle's high performance ADO.NET 2.0 compliant data provider.
Look here : http://www.oracle.com/technology/obe/hol08/dotnet/getstarted-c/getstarted_c_otn.htm
Hope that helps
We make a living by what we get, but we make a life by what we give.
::: Winston Churchill :::