D
Dapeng Wu
Guest
James, You’re right that LOBs will not be read unless they are told so by the application code. Dapeng From: James Palmer [mailto:bounce-jdpjamesp@community.progress.com] Sent: Monday, July 20, 2015 4:46 AM To: TU.OE.RDBMS@community.progress.com Subject: RE: [Technical Users - OE RDBMS] Impact of using BLOB field RE: Impact of using BLOB field Reply by James Palmer 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. Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...