Question


CSC
IN
Last activity: 22 Jun 2016 10:01 EDT
DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Pegasystems Inc.
IN
Hi Seshaiah,
Samuel raised same question here, DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
Do let us know the number of records this table contains.


CSC
IN
Hi Arvind,
Table Size in MB :
300216 |
NO OF RECORDS :
16608223 |
Purge and archive wizard which you have suggested is not applicable for us.At any point of time users want to work on any closed claim and reopen them.


CSC
IN
Kindly provide us if any other approaches are available to overcome this issue.


Pegasystems Inc.
IN
No of records are high.
You can involve DBA to introduce better Indexing on this table.
Hope that helps


CSC
IN
Hi Arvind,
Thank you for early response.
Please provide if we have any recommendations from PEGA.


Pegasystems Inc.
IN
Hi Seshaiah,
In such cases, we suggest to consult database administrator to introduce Indexing that helps in scanning the table faster.


Pegasystems
IN