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@...>
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/
>
>
>