Question
Adding compression to the database will it impact app performance
Just wanted to do an Inquiry, DBA team suggested to have compression set to the application database, wanted to understand if there is an impact to the performance for the pega RSM application.
We are in Oraas db cloud server and Oracle Database
Thanks Sandeep for quick turn around, so you conclusive to say that we should not enable compression in application oraas database rite.Which may impact CPU processing? Does it impact the performance from the application perspective?
Accepted Solution
Not sure what you are trying to get to. However, any impact whether CPU or otherwise will obviously have a cascading effect on your application.
Thanks
Sandeep P V
Thanks Again sandeep, just trying to understand, i went through the article provided, i am trying to find the reason how the compression to db will impact to CPU processing and Application performance. Can you clarify. I mean in what way.
Hi,
Go through the below link, provides more information on the database compression to reduce the disk storage.
https://pdn.pega.com/how-estimate-disk-space-requirements-pegarules-database-oracle
Anyway, the compression in database will definitely have an impact on the server CPU processing. Alternatively, the better approach is to have an archival strategy.
Hope, this information helps.
Thanks
Sandeep P V