Hi,

At Thursday, March 13, 2008, 5:48 AM, skander_sp wrote:

>>
>> Hi,
>>
>> At Wednesday, March 12, 2008, 2:53 PM, skander_sp wrote:
>>
>> > I need to store some documentation in a FB database...
>> > I'm thinking use BLOB row to do.... but I read in diferents post abot
>> > "DO NOT BLOB, use links"
>> > But REALLY is so dangerous to do? slow REALLY down the database
> working?
>>
>> > I read about it, and supossed the blob fields are stored in separated
>> > pages, and only read under request... that is not slow down the work,
>> > index and other works... only grow up the size (of course).
>>
>> > I think store inside is better because I can take more control about
>> > the use, and no one can "rename, modify or delete" from the directori
>> > where I can store it I link. And if the backup is full -not
>> > incremental- I think even better because Im sure the backup is do,
>> > even if someone is reading a field at the moment.
>>
>> > Any REAL pros or contras?
>>
>> > Anyone is using the blob fields for store a big ammount of files?
>>
>> We store the files in blobs and we don't have any issues. When it's
>> in the blob, the user doesn't have to have another link to the server
>> where the files would be. And, as you said, what happens if someone
>> changes the filename directly in the folder?
>>
>> The systems that we developed that stores the files into blobs are
>> currently handling several thousand files and those files can range
>> from a few kilobytes to a few megabytes, with the biggest database
>> that we know of is currently managing over 10GB worth of files inside
>> the database. And, there's no slowdown in retrieval from the database.
>>
>> That being said, there is a difference in the performance compared to
>> retrieving a blob compared to retrieving a file from a file server.
>> But, if the fastest performance is not that important, save the files
>> inside blobs for more convenience. And, we are always trying to save
>> the file zipped within a blob, so that it doesn't take too much space
>> in the database and is smaller when transferring from the database.
>>
>> --
>> Best regards,
>> Daniel Rail
>> Senior Software Developer
>> ACCRA Solutions Inc. (www.accra.ca)
>> ACCRA Med Software Inc. (www.filopto.com)
>>

> Tks Daniel for your experience and opinion.
> One question more.. I-m tinking too on compress file.
> What is your choice for this work? what component or dll? or simply
> your zip the file in disk before "blob" them?

I zip them to a file before placing them in a blob. There are zip
components that you can use for that.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)