[Mono-dev] OracleDataReader problem with too many rows
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
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
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
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