Oracle, LONG RAW and ODBC

Hi !

I am currently using ODBC in a C application to access the database. I am storing and retrieving BLOB as ODBC LongVarBinary type which corresponds to
Image type with SQL Server and LongRaw type with Oracle. Everything works fine but...

Time to put a long raw to Oracle is very very important... 24 to 30 seconds to put
only one megabyte ! Retrieve one Mb is also important : 8 seconds to read 1 Mb.
But with SQL Server times were more like 8 seconds to write 1 Mb and 0.5 seconds to
read it.
Tests are done under the same conditions. Is there anything I didn't understand ?
Of course Oracle is "more" a database than SQL Server, it does more verifications...
but putting binary data in several parts should not be so much time consuming, isn't it ?
What kind of optimization could I provide ?

Any help will be welcome...

Isabelle.

--


* Isabelle Fernandez

* Product Division, Database engineer


* FOCUS Imaging, Les Genets, 449 Route des Cretes, 06560 Valbonne


Sophia Antipolis, France


* Tel: +33 (0)4 92 38 88 15, Fax: +33 (0)4 92 38 96 46,


Mailto:isabelle_at_smtp.focus-fr.com