On 9-10-2014 10:22, 'Tiberiu Horvath' tiberiu_horvath@...
[firebird-support] wrote:

> Hi all,
> I have the following table :
> CREATE TABLE LOG_TABLE (
> ID_LOG_TABLE INTEGER NOT NULL,
> SESSION_ID INTEGER,
> LOG_DATA DATE,
> LOG_TIME TIME,
> LOG_TEXT VARCHAR(100),
> LOG_TEXT_COMPLET BLOB SUB_TYPE 1 SEGMENT SIZE 80
> )
> with some 3000+ records.
> Why does it takes so much time to backup / restore (gbak) this table ?
> (because the BLOB field).
> Do I have any options to speed up the process ?

Without more information that is hard to tell. How large are the blobs?
How long does your backup take, what else is in this database?

I am not sure how gbak reads blobs, but if it honours the defined
segment size, or if you write to the blob in very small segments that
might be part of the problem.

Mark
--
Mark Rotteveel