[Mono-dev] OracleDataReader problem with too many rows

[ygozudeli]

Dear Mono Developers,

First of all, I'm happy with your project. Thanks for your great project. 


I'm using Mono(32 bit) on Solaris  server with AMD processors. There is a
project to dump Oracle rows into HTML file.

I'm Using System.Data.Oracle library, and a stored procedure which returns
rows via ref cursor.

if the rows are less than 10.000 performance is acceptable.

if the rows are about 100.000(I'm of course separating results to multiple
html files)
but  performance is decreasing row by row after 10.000 and by 100.000 it's
about to zero.


But I did the same test on .NET and the performance is linear and so good.

And also, I've made several tests to isolate the problem. It's all about
Reading data

 
Questions:
1. Do you have any suggestion- detailed configuration.. etc?
2. Is there any chance  to use Oracle.DataAccess.Client library on Mono?



-- 
View this message in context: http://www.nabble.com/OracleDataReader-problem-with-too-many-rows-tp21029827p21029827.html
Sent from the Mono - Dev mailing list archive at Nabble.com.