Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle THIN DRIVER info
uncle.scrooge:
Take a look at ((OracleConnection)conn).setDefaultRowPrefetch(x). You'll need to import the classes "oracle.jdbc.driver.*"
Kevin Leben
//Set the default row prefetch setting for this connection
((OracleConnection)conn).setDefaultRowPrefetch (7);
uncle.scrooge wrote in message <380FA6E4.D66232FE_at_worldnet.att.net>...
>
>
>I'm trying to find documentation that describes how to control session
>parameters when
>using the thin driver. Specifically, I'm trying to find out if I can
>control how
>many records are prefetched for large queries. Using the Borland
>DATAGATEWAY, for
>example, the ROWSETSIZE parameter controls that feature. I can either
>get 20 records
>at a time or 1000.
>
>I know I can specify the connect string in the same syntax as the
>tnsnames.ora file,
>but I'm trying to optimize for very large data sets (100K rows, 30
>columns).
>
>any ideas?
>
>
>thx
>
Received on Fri Oct 22 1999 - 08:59:51 CDT
![]() |
![]() |