Dmitrij Vladimirov

Spreadsheet were updated with time spend on run for each method. Used widget: 

I consulted with Eduard about the topic. He suggested a profiling method to gather precise statistic from result set and after that he can help with picking the right method...

Here is a solution to optimize slow loading widgets. This method tries to figure out which cell should not be displayed. The commented lines are the ones that have been...

So progress has been made without implementing DSZ methods, these are purely tweaks in the result set. As @evshvarov pointed out the advantage of DSZ is now around 20 seconds...

@evshvarov take a look on this code. Eduard says that we have to take sql directly from kpi. What if we try this?  TestSQL gets the kpi...

@evshvarov yes it can. Work still in progress but here the preliminary result 

@Lena-Ev Made quick changes to REST. KPI endpoint changed as requested https://github.com/intersystems-ru/Cache-MDX2JSON/pull/98/files#:~:text=%7D-,ClassMethod%20KPIExecute()%20As%20%25Status,%7D,-///%20Wrapper%20for%20%23%23class

@evshvarov's test case is ready. Eduard approved my developments. It remains to do PR and start testing

@evshvarov the new method gets values from KPIs, but tables are not displayed due to missing properties. At the moment, the method has returned what the KPI contains. Are these...