Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
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.