[Mono-dev] OracleDataReader problem with too many rows

[Konstantin Triger]

May be it's another sign to reconsider having JDBC stack for database
connectivity, at least for OleDb namespace.

It's already a long time that ikvm is based on OpenJDK and therefore can be
considered as very solid and compliant.

Taking the Mainsoft System.Data connectivity stack on top of JDBC with
native JDBC drivers looks like a relatively small project.

This seems to provide very reliable solution both vertically and
horizontally since almost every DB vendor has a solid JDBC offering.

Kosta

On Tue, Dec 16, 2008 at 3:54 PM, ygozudeli <ygozudeli at gmail.com> wrote:

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



-- 
Regards,
Konstantin Triger
RSS: http://feeds.feedburner.com/ktriger
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20081217/ef66715f/attachment.html