Hi Mat,
what is your blobs segment size, default?(82bytes?)
( & what is your db page size & what is your disc cluster size)
Firebird engine may be busy for microscopic segmentation and
organization of your large blobs.
i don't care the space savings for such things,
so my blobs segment size is 1024 or more.

Regards.

Ali

--- In firebird-support@yahoogroups.com, mat <mpaczek@k...> wrote:
> Hi!
> I'm writing in reference to my post from friday about very long
lasting
> restore.
> I forgot to mention that about 20% of my database occupied things
> connected with structure, tables and so on.
> The rest (80%) are blobs (table ATTACHMENTS). My database has
about 1,2 GB
> During restore the first part (recreate metadate and all object)
is
> executing very fast (usage of proccessor about 100%). But when it
comes
> to the table with blobs the usage of processor decreases to 1-5 %
and it
> last very long.
> I'm working on linux, CPU 2GHZ, 1GB RAM, fast HDD (60MB/s) so as u
see
> it's rather not the matter of my hardware.
> Is there any solution that can increase the speed of restore
proccess in
> that case?
> Thanks in advance for any help.
> mat