J
James Palmer
Guest
LOBs have the ability to reside in a different storage area to the main record. It is good practise to have a separate storage area just for LOBs. That way you can set the RPB really low which isn't likely to be necessary for the rest of the record. As far as I know the LOB is only read when it is specifically needed by the code, but I don't have anything other than experience to base that on. One of the other chaps will likely come back with a definitive answer. We're running Windows and have made use of the compression functionality in the .net framework to compress all our blobs and it has saved us around 40% disk space (although most of our LOBs are documents rather than images so would expect the compression to be better). Be aware though, that if you do go down the compression route, that when you extract and compress the current records you will find your AI files go mental. Make sure you've got the disk space for it. We didn't. Oops.
Continue reading...
Continue reading...