Question

4
Replies
53
Views
 saravanan kvkandasamy (saravanank1808)
Citigroup technology inc

Citigroup technology inc
US
saravanank1808 Member since 2015 22 posts
Citigroup technology inc
Posted: May 10, 2018
Last activity: May 16, 2018
Posted: 10 May 2018 16:58 EDT
Last activity: 16 May 2018 8:55 EDT
Closed
Solved

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

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 10 May 2018 21:31 EDT
Venkata Sandeep Kumar Pamidamarri (SandeepKumarP_Incess)
Incessant Technologies
Senior Technical Lead
Incessant Technologies
AU

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


 
Posted: 3 years ago
Posted: 10 May 2018 21:52 EDT
saravanan kvkandasamy (saravanank1808)
Citigroup technology inc

Citigroup technology inc
US

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

Posted: 3 years ago
Posted: 16 May 2018 0:45 EDT
Venkata Sandeep Kumar Pamidamarri (SandeepKumarP_Incess)
Incessant Technologies
Senior Technical Lead
Incessant Technologies
AU

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
Posted: 3 years ago
Posted: 16 May 2018 8:55 EDT
saravanan kvkandasamy (saravanank1808)
Citigroup technology inc

Citigroup technology inc
US

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.