On 9-10-2014 10:22, 'Tiberiu Horvath' [email protected] [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 ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
