Question

1
Replies
104
Views
 Bhaskar M (VijayM12)
UBS Ltd

UBS Ltd
GB
VijayM12 Member since 2018 2 posts
UBS Ltd
Posted: September 18, 2019
Last activity: September 24, 2019
Posted: 18 Sep 2019 11:17 EDT
Last activity: 24 Sep 2019 5:17 EDT
Closed

Database size for extra case type

Hi All,

We are using Pega 7.1.9. As part of new requirement, we are adding a new case type which will have a dedicated database table to store workobjects. The process is not so complex and it will have 5-6 screens and capturing lightweight data. In a year, there might be 10K cases will be created. I assume the clipboard size of pyworkpage wont be more than 1MB.

Please could you let us know, if we need to increase the database size and any other hardware sizes. And if yes, how much should it be. Please could you provide an absolute answers for sizing if possible.

Thanks

Case Management 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: 1 year ago
Posted: 24 Sep 2019 5:17 EDT
Venkata Chalapathi Janapati (janav)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Vijay,


From the above, approximately you need 10 GB space for year.


1 WO ~ 1 MB


10,000 WO / year ~ 10 * 1000 WO ~ 10 * 1000 MB ~ 10 * 1024 MB ~ 10 GB / year


If you are purging the WOs (with resolved state) on timely manner, then required size may comedown.


Can you also please check with your application architect and DB admin to conclude the things.


Warm regards,


Venkat