Standard Chartered Bank
Last activity: 20 Feb 2019 16:00 EST
Database LOB Sizing and Performance Optimization
We had a performance issue due to contention on DML on table with lobs, as a temporary workaround allocated free space to lob. I have gone all the way through attached PEGA advise on LOB sizing in DB, from the document it says "Compression, which can reduce BLOB size by a third or more, is enabled by a property setting in the PRPC pegarules.xml file (versions 4.x and earlier) or the prconfig.xml file (versions 5.x and later). Compression is turned on by default. Refer to PRKB-9850, How to Compress the BLOB Values in the PegaRULES Database, for further information."
I have tried to dig up the information about PRKB-9850, but no where it was originate. Could you help me about this.
Also one attractive thing I found was:
Add the below code in prconfig.xml to compress the BLOB before saving it to the database:
<env name="compatibility/deflatestreams" value="true" />.
In our current environment setup we don’t have the above code in prconfig.xml. could you concise what is this for and can we compress the blob by adding above proposal in prconfig.xml file.
Much be pleased about your worth answer on above two queries.
App Server: JBOSS EAP 6.4
DB: Oracle 11g