Managing so many optimized properties
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?