Subject Re: [firebird-support] Store large amount of Binary Data in FB
Author Martijn Tonies
> >>> How can I store these files in the BLOB field?
> >>>
> >>> Is it advisable to store such huge binary data in FireBird?
> >>>
> >> not really
> >>
> >
> > Really? Why not?
> >
> >
> 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

If someone proves me wrong, I stand corrected, but as far as I know...

> > This is a very old discussion and it comes up now and again in all
> > lists concerning database systems.
> >
> indeed :)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!