[Mono-dev] OracleDataReader problem with too many rows

Eyal Alaluf eyala at mainsoft.com
Tue Dec 16 08:43:57 EST 2008


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
DataSets/Tables are complex data structures and the current
implementation may well have a problem with hosting 100K rows


-----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

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

I'm Using System.Data.Oracle library, and a stored procedure which
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
html files)
but  performance is decreasing row by row after 10.000 and by 100.000
about to zero.

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

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

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

Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com

More information about the Mono-devel-list mailing list