Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
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.