Aydin Toprak (topra)
Senior System Architect
Pegasystems Inc.
topra Member since 2016 19 posts
Posted: June 13, 2018
Last activity: August 8, 2018
Posted: 13 Jun 2018 5:53 EDT
Last activity: 8 Aug 2018 10:10 EDT

Managing so many optimized properties

Dear all,

I am supporting on an application which is expanded heavily in years and cannot handle current status.

We have more than 900 properties on the application and some of them are exposed.

The column size of our work table is around 360 and still increasing as a result of new requests of search and reporting.

The column population job is not working properly as I heard some issues about our "Work" table which causing some issues on DB. The problem is seems all about the number columns on the table.

Do you any solution for me to solve this issue while keeping the existing architecture?

Thank you

Data Integration System Administration
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.