Em 25/4/2014 01:31, liviusliv...@poczta.onet.pl escreveu:
Hi,
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
Regards,
Karol Bieniaszewski
Nope...
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 !