> > The problem rise when i need to insert a really big blob.
>
> How big is the very big blob? There are a couple of known problems wit
> blobs over 2Gb, one having to do with gbak and the others with stream
> blobs.

105 MB

>
> > If i copy old data to other database and delete copiyed data ( working
> > database ), my problem disapears?
>
> I think so, but without seeing the database or knowing something more
> about it, I can't

Ik, i will try,

here more info of my database:

/* Table: STATEMENTS */

CREATE TABLE STATEMENTS (
CUENTA APLHA_10 COLLATE WIN1251,
FECHA_PROCESO FECHA,
FRF_STATEMENT ST_BLOB);

/* Indices definition */

CREATE INDEX STATEMENTS_IDX1 ON STATEMENTS (CUENTA);
CREATE INDEX STATEMENTS_IDX2 ON STATEMENTS (CUENTA, FECHA_PROCESO);

CREATE DOMAIN ST_BLOB AS
BLOB SUB_TYPE 0 SEGMENT SIZE 100 CHARACTER SET WIN1251

CREATE DOMAIN FECHA AS DATE
alpha_10 is varchar 10

in the blob i am storing compresed frp fastrepotr documents ( bank
statements )

These repository is accessed internally using t1 lineusing a Delphi
applicacion using Reamobjects middleware.

The inserts are made using regular client/server aplication with IBX.

In the next version i will use UIB bacuase i get better insertion
times and i will include some descripction and naming fields.

i hope this help, in case i can't resolve my problem.


thanks and regards,
Dennis Ortiz