Direct Oracle Access - High performance


Array Fetching allows you to specify the number of records that will be fetched from the server in one network roundtrip. You can optimize this separately for each select statement that you execute, thereby minimizing the number of network roundtrips.

Array DML provides the possibility to insert, update or delete many records with just one statement. This minimizes network traffic and the number of statement executions, and is primarily useful in batch applications.

PL/SQL Blocks can execute several SQL and PL/SQL statements at once, again reducing the number of network roundtrips and statement executions.

PL/SQL Tables are array structures that can be passed to a stored procedure, or more generally, to a PL/SQL Block, providing a way to process a lot of information at once

The StatementCache feature provides and manages a cache of statements for the session. On the server cursors are ready to be used without the need to parse the statement again, even if these cursors are closed by the application on the client. The StatementCacheSize property determines the maximum number of cached statements. The least recently used statements will be removed from the cache when this maximum is reached. This ensures that only the most frequently used statements remain in the cache, and also ensures that the database will have a minimal number of open cursors.

The Direct Path Load Engine is encapsulated in the TOracleDirectPathLoader component, and requires Net8 8.1 (the Oracle8i client). It uses the same mechanism as SQL*Loader to write data directly into the physical database blocks without using SQL Insert statements.