Slow datareader performance with ODP.NET

[Felix Faassen]

Hi,

I'm having some problems with reading data from an Oracle 9i database
using the datareader implementation from the ODP.NET Provider.

I need to fetch around 50.000 -100.000 records, store the data in a
custom dataset. However fetching the data takes around 30 sec till a
minute. This is unacceptable since it's a webservice.

I know it's generally a bad design desicion but paging is not an option
here. Are there any possibilities to boost up the performance?

Thanks

Felix Faassen

 

[Guest]

You are going to have a speed issue with a web service on this type of
application, as you are pushing through tons of data. YOu can reduce some of
the footprint with a Remoting Service, but all you will really gain is the
elimination of HTTP (and possibly IIS).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Frans Bouma [C# MVP]]

Hi,

I'm having some problems with reading data from an Oracle 9i database
using the datareader implementation from the ODP.NET Provider.

I need to fetch around 50.000 -100.000 records, store the data in a
custom dataset. However fetching the data takes around 30 sec till a
minute. This is unacceptable since it's a webservice.

I know it's generally a bad design desicion but paging is not an option
here. Are there any possibilities to boost up the performance?

fetching data yourself in a dataset using a datareader might be slower
than returning a REF CURSOR and binding that to a datatable using
OracleDataAdapter.

For example, do you use datareader.IsDbNull?

Though fetching 100,000 rows into a dataset will take some time. What
gave you the thought it would be instant?

FB


--