topra Member since 2016 18 posts
Posted: 2 years ago
Last activity: 2 years 2 months ago

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
Share this page LinkedIn