| What is the fastest way of getting BLOB data into 9i? [message #168467] |
Thu, 20 April 2006 10:34  |
adamb
Messages: 6
Registered: April 2006
Location: London, UK
|
Junior Member |
|
|
What is the fastest way of getting BLOB data into 9i? My tables have the form:
create table A
(KEY_COL VARCHAR2(1024),
FIRST_BLOB BLOB,
SECOND_BLOB BLOB
)
;
I've tried the object-navigational interface in OCCI. The retrieval speed is great but when my BLOBs are big insertion is very slooooooow.
I've also tried Direct Path loading using OCI. But that has turned out to be slower than attempt 1, above.
The slow down may be due to the more efficient way that data is stored when using object-navigational vs Direct Path: out-of-line vs in-line data respectively.
Anyway, I'm very new to this so if you can suggest another approach I will very much appreciate Smile
Adam
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
