Performance problem with ODP.NET

See more:

C#

Hi!

I am reading data from Oracle database by using ODP.Net with the follwing code

OracleConnection con = new OracleConnection(connectionString);
        OracleCommand cmd = new OracleCommand(_SELECT ID,RECORD(XMLType) FROM tbl_Name, con);
        con.Open();
        OracleDataReader _dataReader = cmd.ExecuteReader();
        _dataReader.FetchSize = cmd.RowSize * 25;

 		while (_dataReader.Read())
                	{
		 string rowId = _dataReader[0].ToString();
                     string xmlString = _dataReader[1].ToString();
		adding this data into Queue for further processing
		        }

It working fine but in a minute it's reading only 10000 record. If I use SqlServer database it's reading 500000 record in minute having table with same schema. I am not getting why this much difference between two databases.

For improvement I tried with following options:

Pooling=true/false;
Statement Cache Size=0/1;
_dataReader.FetchSize = cmd.RowSize * 25;

but no improvement at all.

Please help me if I am missing something to read data faster using ODP.NET

Thank you.

-Dattatrya Moin