This is my first c# windows app.
I create a data reader on an Oracle table. Returns 552 rows. I iterate
thru them, goes like light speed.
Next, for each row returned, I need to fetch from another table to get
some other information. When I do that, my program takes 20s instead
of 1s. I even downgraded my inner SQL to become "select 1 from dual",
same performance hit!
Is there a problem with Oracle under c# using two DataReader at the
same time?
Here's the code:
con = new System.Data.OracleClient.OracleConnection();
con.ConnectionString = "user id=xx;data source=xx;password=xx";
public void Process(ProgressBar progBar)
{
OracleDataReader dr;
OracleCommand cmd;
dr = GetMainDR()
while (dr.Read())
{
// get some columns
...
cmd = new OracleCommand("select 1 from dual", con);
Decimal i = (Decimal) cmd.ExecuteScalar(); <----- slows down
everything
cmd.Dispose();
...
}
}
public OracleDataReader GetMainDR()
{
OracleDataReader dr;
OracleCommand cmd;
cmd = new OracleCommand("select * from TABLE_OF_552_ROWS", con); //
change
dr = cmd.ExecuteReader();
return dr;
}