poor OracleClient performance?

[Guest]

Hi all,

in the process of migrating from 1.1 to 2.0 i´m experiencing massive
performance losses within the database access to a oracle database (same
effect on 9 and 10)
the following code is built in 1.1 and 2.0 (except the stopwatch of course).
The 1.1 application is finished in less than the half time than the 2.0 app.
(talking of 2.1 seconds instead of 4.4 seconds). table1 is a table of about
12000 rows and 35 columns, running well in a production environment.

// test button handler:
string result = "";
label1.Text = "test running... pls wait";
label1.Refresh();
Stopwatch w = new Stopwatch();
w.Start();
using (OracleConnection oc = new OracleConnection("Data
Source=XXXXX.world;Persist Security Info=True;User
ID=XXXXX;Password=XXXX;Unicode=True"))
{
oc.Open();
using (OracleCommand cmd = new OracleCommand("SELECT * FROM table1",
oc))
{
using (OracleDataAdapter ada = new OracleDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
ada.Fill(dt);
}
}
}
}
w.Stop();
result += " r: "+w.ElapsedMilliseconds;
System.Diagnostics.Debug.WriteLine(result);
label1.Text = result;


The performance loss can be reproduced with other sql statements and
different tables in different Oracle databases. It´s just the OracleClient
assembly that makes the difference.


Can anyone confirm this performance loss?

 

[Miha Markic [MVP C#]]

Hi,

I suggest you to try using one of the performance profilers out there to
pinpoint the bottleneck.
The difference (if there is really one) might be a consequence of DataTable
modifications, too.
I guess one should try running similar samples with other databases to
verify this (although I doubt it).