[Mono-dev] OracleDataReader problem with too many rows

[Eyal Alaluf]

Hi.

Are you using DataSets and DataTables for maintaining the data? Is it
possible that they are the bottle-neck rather than reading the data from
the oracle Database? You may check that easily by simply using a
DataReader and dumping the data directly to a file instead of using
DataTables.
DataSets/Tables are complex data structures and the current
implementation may well have a problem with hosting 100K rows
effectively.

Eyal.

-----Original Message-----
From: mono-devel-list-bounces at lists.ximian.com
[mailto:mono-devel-list-bounces at lists.ximian.com] On Behalf Of ygozudeli
Sent: Tuesday, December 16, 2008 2:49 PM
To: mono-devel-list at lists.ximian.com
Subject: [Mono-dev] OracleDataReader problem with too many rows


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-tp2102
9827p21029827.html
Sent from the Mono - Dev mailing list archive at Nabble.com.

_______________________________________________
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list