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 ?

 

 

 

Thank you,

 

Tiberiu