|Subject||Re: Odp: [firebird-support] Request for advice|
|Author||Alexandre Benson Smith|
Em 25/4/2014 01:31, liviuslivius@... escreveu:
But you also misunderstud advice.
Blobs are not stored in table with its other fields. In record exists only blob id and blob is stored on separate pages. Then moving it to separate table do nothing.
But i always prefere store big data like document scans outside of database and in main database have only some hint about file name without final location.
Only application have knowlage about final location and can load document
If the blob is small enough to fit on the data page with the records it will be stored there. I don't remember the rule exactly, but it is how it works.
It reduces dramatically the number of records per page, once the most of the page are used to store the blob content.
see you !