Subject Re: [firebird-support] Store large amount of Binary Data in FB
Author Teträm Corp
Martijn Tonies a écrit :
>
>> yogiyang007 a écrit :
>>
>>> Hello everyone,
>>>
>>> I am trying to create a software in which all the documentations that
>>> are generated in our organization should be stored.
>>>
>>> For this I have created a BLOB type field also.
>>>
>>> Now my problem is that the data that I want to store in this BLOB
>>> field consists of a variety of files which are .DOC, .TIF, .JPG, .RTF,
>>> .TGA, .PDF, .XLS, .PNG, .DWG, .DXF. The average file size is around 23
>>> MB and there are currently 300 files.
>>>
>>> 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)
> This is a very old discussion and it comes up now and again in all
> lists concerning database systems.
>
indeed :)