Question

5
Replies
357
Views
SatishAnnam Member since 2017 2 posts
Standard Chartered Bank
Posted: 2 years ago
Last activity: 1 year 6 months ago
Closed

Database LOB Sizing and Performance Optimization

Dear All,

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.

Environment Details:

PEGA 7.2.2
App Server: JBOSS EAP 6.4
OS: RHEL6-U2-x86_64
DB: Oracle 11g
Java: 1.8

Thanks,

Satish Annam.

Data Integration
Moderation Team has archived post
Share this page LinkedIn