Subject | RE: [firebird-support] BLOB Restore Speed |
---|---|
Author | Carrell Alex |
Post date | 2009-10-21T07:28:22Z |
I have not seen anyone reply.
So I wonder what the page size of the database is?
We have a database for blobs, specifically files around 2-12mb. It was slow reading / writing long ago. I changed the page size from 2048 through to 16384. I played with 8096, but found 16384 to work well, given the Ram restraints I had at the time. Very noticeable change in performance. The change used more disk space but that did not matter.
Backup restore of these tables ~10gb per year is not v slow. about 2 hours, on a 6 year old machine, xeon 1.8ghz x2 (hypethreaded to 4), 3gb ram. On a moderen machine (double everything), the databases restore in is in =< hour, over fibre channel to a san.
alex
This message and any attachments (the message) are intended solely for the addressees and are
confidential. If you receive this message in error, please delete it and immediately notify
the sender. Any use not in accordance with its purpose, any dissemination, copying or disclosure,
either whole or partial is prohibited without prior formal approval. The internet cannot
guarantee the integrity of the message. The companies of Bobst Group do not accept any liability
for data corruption, delay, interception or any modification in relation with this message.
So I wonder what the page size of the database is?
We have a database for blobs, specifically files around 2-12mb. It was slow reading / writing long ago. I changed the page size from 2048 through to 16384. I played with 8096, but found 16384 to work well, given the Ram restraints I had at the time. Very noticeable change in performance. The change used more disk space but that did not matter.
Backup restore of these tables ~10gb per year is not v slow. about 2 hours, on a 6 year old machine, xeon 1.8ghz x2 (hypethreaded to 4), 3gb ram. On a moderen machine (double everything), the databases restore in is in =< hour, over fibre channel to a san.
alex
This message and any attachments (the message) are intended solely for the addressees and are
confidential. If you receive this message in error, please delete it and immediately notify
the sender. Any use not in accordance with its purpose, any dissemination, copying or disclosure,
either whole or partial is prohibited without prior formal approval. The internet cannot
guarantee the integrity of the message. The companies of Bobst Group do not accept any liability
for data corruption, delay, interception or any modification in relation with this message.