Subject Re: [firebird-support] gbak restore without -service switch very slow for db with lots o blobs
Author Michael Ludwig
Stefan Sinne schrieb am 20.04.2010 um 17:39:44 (+0200):

> I have a database of about 23 GB with just one table, storing around
> 13.000 documents in a blob field.
> The backup of this database works fine finishing in less than 20
> minutes and creating a backup file of 22 GB.
> But when I try to restore the database with gbak it takes over 10
> hours (when I finally killed the process) using the following command:
> /opt/firebird_21_CS/bin/gbak -c -v -p 4096 -user [...]

I'm unable to answer your question, but given that you mostly store
clunky data items in BLOB columns, wouldn't your database benefit from
raising the page size to the maximum value of 16384?

Michael Ludwig