Array Fetches in Oracle 7
\The Sandbox \PB History & Future \New in PB 4 \DB Enhancements \Array Fetches in Oracle 7
Array Fetches
in Oracle 7
Bind Variables
Cached
Statements
Select & DB
Painters
Remote Procedure
Informix
ODBC
Oracle 7
Peformance
Gains
Cache in
Oracle
SQL Server
System 10
Watcom 4.0

TheOracle 7 driver allows much larger array fetches. In 3.0, fetched arrays were restricted to 32K for all columns. In 4.0, the fetched arrays can be as large as Oracle 7 will allow, 32K per column. The default number of rows that can be bulk fetched for a DataWindow retrieve has been has been increased to a maximum of 1000 rows, the default maximum in 3.0 was 100 rows. As in 3.0, a user can override our defaults by specifying the BLOCK= parameter in the DBParm. 

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com