Last post Jul 16, 2010 01:30 AM by PassHours
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.
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