Re: .Net version 1.1 data fetch rate

They are using the DataReader, but the parse to execute ratio is 1 to 1, with many fetches.

I'll pass the information along and see if I can encourage them to investigate the OracleDataAdaptor. Procedures are being used but need some improvements from what I've seen so far. I believe is some time testing done on a regular basis, but apparently, some users aren't adjusting their filters as expected :)

thank you ... Robyn

On 4/5/07, Bryan Michael Lenihan <bryan_at_orixcorp.com> wrote:
> Robyn,
>
> Is your developer using DataAdapters or are they processing the data using
> the DataReader? Also, is your Parse to Execution Ratio very high? These
> are common issues that I have seen using the Microsoft data providers. I
> hope that your developer is at least using the System.Data.OracleClient.
>
> I have done several time trials, not scientific at all, but for basic
> testing. I am pretty convinced that the best method for retrieving data
> from the database is using Stored Procedures with SYS_REFCURSOR and loading
> the data into a System.DataTable using the OracleDataAdapter.
>
> FYI: You will not get that much better performance using .Net 2.0 when it
> comes to the Oracle Client data provider.
>
> As always you should do a little time trial and test your chosen method
> before using it in your application.
>
> Thanks,
> Bryan
>

--
http://www.freelists.org/webpage/oracle-l