Peformance Gains
\The Sandbox \PB History & Future \New in PB 4 \DB Enhancements \Peformance Gains
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

Using bind variables and cached statements can improve the performance of most applications. The amount of improvement depends on the application; applications with a large amount of transaction processing generally benefit the most. Our tests showed improvement even running a small application on a LAN; a number of DBMSs were 2 times faster when bind variables and cached statements were used. 

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

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