| |
 |
|
ss
Oracle Tips by Burleson |
Direct Load
Direct load is Oracle feature designed to
implement faster loading of large data quantities. During the direct
load, SQL is bypassed, the client pre-formats Oracle blocks and
Oracle's database writer process, popular DBWR, writes the block to
the disk. This usually results in shorter path through Oracle code,
bypassing the SQL engine and making extremely fast writes, thus
shortening the load time drastically. In newer versions of Oracle, the
client library also known as OCI library has that capability. If
C/C++ bindings are used, one can write an application utilizing the
direct load capability. PHP5 does not implement this feature of OCI
library. That, however, doesn’t prevent scripts from using the /*+
APPEND */ hint in insert statements. Same as with the array interface,
this feature is not very useful for the web applications.
See
code depot for complete scripts
The above book excerpt is from:
Easy Oracle
PHP
Create Dynamic Web Pages with Oracle Data
ISBN
0-9761573-0-6
Mladen Gogala
http://www.rampant-books.com/book_2005_2_php_oracle.htm
|
