Stimulsoft Business Intelligence System | Forum

I user the version Dashboards.JS 2019.2.2,
It works well, but there are still some problems.
When I query the database with sql, I only have one data set, but the more data controls I put on the Dashboards page, the more times the data set queries the database in preview. In theory, it should only query the background once. Thank you!

XHRPOSThttp://192.168.1.211:8080/bst/ecore/EcoreBasQuery_queryMRT
[HTTP/1.1 200 OK 118ms]
XHRPOSThttp://192.168.1.211:8080/bst/ecore/EcoreBasQuery_queryMRT
[HTTP/1.1 200 OK 25ms]
XHRPOSThttp://192.168.1.211:8080/bst/ecore/EcoreBasQuery_queryMRT
[HTTP/1.1 200 OK 22ms]
XHRPOSThttp://192.168.1.211:8080/bst/ecore/EcoreBasQuery_queryMRT
[HTTP/1.1 200 OK 23ms]
XHRPOSThttp://192.168.1.211:8080/bst/ecore/EcoreBasQuery_queryMRT

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

I mean I only have one data set (SQL). When I browse DASHBOARD, it should only query the database once, but it query the database many times, which should be problematic!
I use the code in my project 'Stimulsoft.Report.Dashboard.StiCacheCleaner.clean();';
Thank you

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Lech Kulikowski wrote: ↑Thu Mar 28, 2019 3:32 pm Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Here is the demo，in browser，you can press F12 to found that there is lots of query with ‘http://127.0.0.1:8080/dsbug/data.txt’；

Hello,

We have added some optimizations in that direction. Please check the next release build.

Thank you.

Lech Kulikowski wrote: ↑Wed Apr 03, 2019 6:25 pm Hello,

We have added some optimizations in that direction. Please check the next release build.

Thank you.

I tested the latest version of dashBoard. JS 2019.2.3, and I found that there was still has this problem, which step I lacked, or whether I needed to wait for the next version. Thank you!

Hello,

Please check the next release build which will be available within one or two weeks.

Thank you.

I tested the latest version（2019.3.1） and still had this problem.

Hello.

Sorry, for the issue. Maybe we have made an improvement in other place.
We have reproduced the issue on our latest build and will let you know when we make an improvement and check it on your sample.

Thank you.

Ticket reference: #8329