[Mono-dev] OracleDataReader problem with too many rows

ygozudeli ygozudeli at gmail.com
Tue Dec 16 08:54:02 EST 2008


As I said, I'm only using OracleDataReader, Oracle Stored Procedure with ref
cursor and Oracle Connection of course with a command. No DataSet, no
dataTable... And, I'm absuletly dumping the data directly as you said also
I'm not using any string, stringbuilder etc explicitly. Reading 5 columns
and concating and writing to text file, while DataReader reads .

 But it's not working with a linear performance. 

And as I said the issue is isolated. Nothing else, but OracleDataReader...

Thanks for your hand.



Eyal Alaluf wrote:
> 
> 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
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
> 
> 

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



More information about the Mono-devel-list mailing list