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 -> How to increase ODynaset performance ?

How to increase ODynaset performance ?

From: Harry Li <hli_at_arkipelago.ca>
Date: Wed, 14 Jul 1999 17:17:58 -0400
Message-ID: <378cfe60@news.vphos.net>


Hi:

    I am using oracle object for ole32 in the client side (windows 98 on PII, 128RAM), the
Oracle Server is an not-very-old HP server. The network is LAN which is fairly fast. I tryed
 to retrieve a record set using ODynaset with read-only and no-cache options,
the record set is very big, about 500,000 records of 3 NUMBER columns. It take me
about 10 minutes to browse it from top to bottom. Is it normal, or have I done
something wrong?

       Thanks !

Harry Li Received on Wed Jul 14 1999 - 16:17:58 CDT

Original text of this message

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