Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Clobs extremely slow? Or is it my fault?

Re: Clobs extremely slow? Or is it my fault?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sun, 13 Feb 2000 23:01:25 +0200
Message-ID: <38A71BA5.5A2F351A@0800-einwahl.de>


How big are your CLOBs?

Martin

ajeru wrote:
>
> In article <38A5A398.815051D7_at_rationalconcepts.com>,
> "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:
> > Hi,
> > have you tried using streams to get the data?
> >
> > Clob clob = rs.getClob(3);
> > InputStream instream = Clob.getAsciiStream(); // Or Reader r =
> > Clob.getCharacterStream();
> > instream.read(...);
> //
> > r.read(...);
> >
> > cheers,
> > cindy
> >
>
> Thank you for your answer. Yes I've tried that too. Unfortunately it's
> all the same. I think this must be a bug or some version problem because
> 20 seconds for 100 records is way to much to be usful to anybody I
> think.
>
> --
> Alexander Jerusalem
> Xajeru_at_gmx.netX
> To mail me remove the Xes
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Feb 13 2000 - 15:01:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US