Hi,

I store some zipped data into a blob. I have blob columns with
sub_type 0. I think this is the preferred subtype for zipped data.

I did some performance tests and it seems that the db really slows
down around 2,5 ko.

Here is the ddl creation script of my table :
create table ENSEMBLE_RESULTATS (
ENSEMBLE_RESULTATS_ INTEGER not null,
DATE_ DATE,
COMPTEURS_ BLOB,
CREDIT_DEBITS_ BLOB,
ABSENCES_ BLOB,
ACTIVITES_ BLOB,
ANOMALIES_ BLOB,
ASTREINTES_ BLOB,
CENTRES_CHARGE_ BLOB,
HEURES_SPECIALES_ BLOB,
HEURES_SUPPLEMENTAIRES_ BLOB,
PRIMES_ BLOB,
SOLDES_ABSENCE_ BLOB,
SALARIE_ INTEGER,
primary key (ENSEMBLE_RESULTATS_)
);

I did two test series:
- In the first one I insert blobs around 2200 bytes. The average time
is around 100 ms.
- In the second one I insert blobs around 2600 bytes. The average
time is around five seconds (with few tests around 100 ms).

I really don't understand why there is such a difference. I tried to
create a database with a bigger page size but it does not seems to
make any difference.

Does somebody can explain me why I have these results

Thanx

Seb