problem of performance with BLOB field

Hello,

I wrote a small program in VC ++ 5 that allows to store and get a file in a BLOB.
The field is a MEMO on ACCESS, an IMAGE on SQL Server and a LONG RAW on Oracle.
I use the ODBC API SQLGetData et SQLPutData, I am working with buffers of 2K inside a transaction

I use the same code for ACCESS, SQLSERVER and ORACLE.

The ODBC drivers ODBC are :
Microsoft 3.50.360200 for Access
Microsoft ODBC driver for Oracle 2.00.006325 Sql Server 2.65.0240

The files are compressed before storing in the Database. All is OK, but i have some performance problem on Oracle.

I try to store a file of 8Mo allready compressed

The result is

        Put (secondes) Get (secondes)

Access 34 26
(base on the serveur)         

Sqlserver 6.5 63 25

Oracle 7.3 604 More than one hour

The client is a Gateway P5-166 with 64MO under NTWS the server is a Gateway PRO200 with 128MO under NT server.

I have very bad result with Oracle, 1 s for 2K in reading.

I try to:
Change the size on the buffer (1K, 2K, 8K, 1M, 10M) Change the size of the segment on the table (15M for INITIAL EXTENT and 0% for PCT_INCREASE)
use a ROLLBACK SEGMENT of 15M for the transaction

But it is allways very bad.

Can you help me ?

Roch Auburtin
AGS Soft
26 rue Benoît Bennier
" Les bureaux verts "
69260 Charbonnières les bains
Tel : 04 78 87 29 29
Fax : 04 78 87 29 29
Email : agssoft_at_ags.net Received on Thu Oct 23 1997 - 00:00:00 CEST