Subject | firebird-support] restoring database with blobs |
---|---|
Author | mat |
Post date | 2005-07-18T07:36:33Z |
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
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