Slow datareader performance with ODP.NET

  • Thread starter Thread starter Felix Faassen
  • Start date Start date
F

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
 
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!
***************************
 
Felix said:
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?
Click to expand...

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


--
 
Back
Top