Re: Oracle THIN DRIVER info

From: Kevin Leben <kevin_leben_at_hp.com>
Date: Fri, 22 Oct 1999 07:59:51 -0600
Message-ID: <7upqlf$e32$1@fcnews.fc.hp.com>

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