Question
Can we find out the work object / data associated with the work object for DB planning
Hi there,
Is there a way to find out how big (e.g. kb) of a work object record in the current DB so that we can use to do a rough calculation the table / DB sizing.
I will need the average size of work object and data associated with the work object takes up in the database.
Regards
Seri
Message was edited by: Lochan to add Category
Accepted Solution
Hi Rajiv,
Yes, but do I do SQL to select BLOB ? or do we have Pega function to count the byte from the BLOB
There is no OOTB SQL function in Pega platform for this. You will need to write SQL to do this (either within the platform or directly using a SQL client against the DB)
To me it seems so complicated that it's perhaps easier to determine the space needed by actually observing how much space is used.
Here are some of the considerations for space needed:
- blob space for work object and non-blob space for work object
- blob and non-blob space for each assignment on that work object
- space for all the attachments
How about measuring how much space is used by the db, then making some work and assignments and typical attachments, and measuring the space again, and using the observed value for your ballpark figure ?
/Eric
I recommend you read this article and the references in it (or send it to DBAs): https://pdn.pega.com/performance-guidance-production-applications-database
The length of the BLOB is a good indication of the size of the work object (case). I assuming you will be using your Dev / QA to get a ballpark on the size so that the staging / production can be sized appropriately.