Subject Re: [firebird-support] Store large amount of Binary Data in FB
Author Milan Babuskov
Martijn Tonies wrote:
>>afair, storing as huge blob as Yogi Yang needs reduces FB1.5 (don't know
>>for newer versions) performances (at least effectiveness of indexes)
>
> I wouldn't know why... Indices are affected by the number of items
> that can fit in a page and the selectivity, this has nothing to do with
> blobs.

AFAIK, Martijn's right. The BLOB data itself is not kept on the same
page, so it doesn't affect index at all. Perhaps 'Tetram Corp.' could
tell us where they read it?


--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org