then, how should i decide on segment size of the binary object for
instance i save the document into blob field that may cause arround
50 kb for instance or 100kb , 1Mb and so on ?
or how should i determine the segment size for different size of
binary object to reach the most optimize database performance, i
major concern is to get to know the impact on segment size ...


TIA

--- In ib-support@yahoogroups.com, "Clausheeg" <heeg.c@t...> wrote:
> Hi this is also interessting to me...
> I played with BLOBs (storing Tiff files) database was growing up to
4.6 GBs
> in MAC OS X 64bit IO support.
> The database page size was 32K and the blob segment 32K;
> I found that after 2000 TIFs the lookups and further stores were
slow.
> This cd also be the index I used. After a gbak/ restore it was fast
again.
> I then decided to have separated database files for a each group of
TIFs.
> the biggest was 1800 files and had 1.8 GB this showed better
performance
> wihtout having gbak/restore.
> yours
> Claus
>
> ----- Original Message -----
> From: <benny@c...>
> To: <ib-support@yahoogroups.com>
> Sent: Thursday, December 26, 2002 10:49 AM
> Subject: [ib-support] any impact of segment size for read
performance
>
>
> > is there any impact on declaring the different segment size on
> > allocating the same size of binary object on read performance?
> > and did declaring different subtype would have impact in read
> > performance ?
> >
> > i need to know what the blob would actually bring effect on
database
> > write or read performance specially when it come to decide which
kind
> > of sub_type and segment size would be most suitable for me to
include
> > text or the binary object.
> >
> > i tried to find any impact on database size by using the different
> > different segment size on allocating the same size of text. but i
> > failed to view any differences. so i suspect there might be some
> > impact on read performance .. am i thinking correctly?
> >
> > any comment would be appreciated.
> >
> > TIA
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >