Quetions about Dashboards.JS query

Stimulsoft Dashboards.JS discussion
aixmo
Posts: 20
Joined: Mon Mar 25, 2019 7:19 am

Quetions about Dashboards.JS query

Post by aixmo »

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
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski »

Hello,

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

Thank you.
aixmo
Posts: 20
Joined: Mon Mar 25, 2019 7:19 am

Re: Quetions about Dashboards.JS query

Post by aixmo »

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
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski »

Hello,

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

Thank you.
aixmo
Posts: 20
Joined: Mon Mar 25, 2019 7:19 am

Re: Quetions about Dashboards.JS query

Post by aixmo »

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’;
Attachments
dsbug.rar
(5.17 MiB) Downloaded 249 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski »

Hello,

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

Thank you.
aixmo
Posts: 20
Joined: Mon Mar 25, 2019 7:19 am

Re: Quetions about Dashboards.JS query

Post by aixmo »

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!
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski »

Hello,

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

Thank you.
aixmo
Posts: 20
Joined: Mon Mar 25, 2019 7:19 am

Re: Quetions about Dashboards.JS query

Post by aixmo »

I tested the latest version(2019.3.1) and still had this problem.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Quetions about Dashboards.JS query

Post by HighAley »

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
Post Reply