It seems that this behavior is not on all my computers.
It occurs on a PII 400Mhz on w2k with 128 Mo of RAM.
The overead seems to be due to page faults. Is there a way to tune that ?

Thanx

Seb


On Tue, 28 Sep 2004 16:26:53 +0200, Sebastien Cesbron
<scesbron@...> wrote:

> 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
>

--
-------------------------
Pour ceux que ça intéresse j'ai 6 invitations gmail