Hi!
My blob segment size is default (will be enough if I change it to 1024
or more?) , my db page size is 2048, my disc cluser size is 4kB
I tested it with various file systems: reiserfs, ext3, win system file
but the situation is still the same.
Any ideas what should i do now?
regards
Mat

> 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
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>

--
Pozdrawiam,

Mateusz Pączek