Close popover
Chakravorty Amit (AMITTUTUN)

AMITTUTUN Member since 2011 62 posts
Posted: November 10, 2017
Last activity: November 10, 2017

Optimization of property


We have a report definition which is extracting lot of data from BLOB and sql has multiple pr_read_from_streams which is a very expensive operation on the database. This also also the sql which is running when our database went to recovery mode. We decided to optimize the properties. Now we have lakhs of records where the value needs to be populated in the optimized column. One approach is

1) login to developer portal in production environment and click optimize for reporting on the property. I am not sure if this is best practice. The column population job will automatically populate the data but it requires time to populate all the data and the problem is business user will see empty value during hours of operation.

2) Use sql query to populate column and run activity to populate column values. But again lakhs of recors are there and it will take time to populate and business will see empty values in the UI for those properties.

Let me know any better approach for this scenario and if above two approach is option then how to mitigate empty value problem

Data Integration Reporting
Moderation Team has archived post,
Close popover 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.