Posted: 19 Jun 2018 8:58 EDT 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.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of this screen and also on our Pega Support Community homepage. Once created, please reply back here with the URL of the new post.