Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

Feedback

Using Read-only, Forward-only Dynaset

If your application does not need scrollable dynaset, then you can create forward only dynaset with ORADYN_NOCACHE (H8) option. With this option, performance improvement can be gained by eliminating the overhead of creating local cache file and the overhead of reading/ writing data from that file.

If the application does not make any update to the dynaset, then you can create read-only dynaset with ORADYN_READONLY (H4) option. With this option, performance improvement can be gained by eliminating the overhead of local parsing of SQL statement and reducing network trips for SQL statement execution.


 
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents