Quetions about Dashboards.JS query

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

Quetions about Dashboards.JS query

Post by aixmo » Mon Mar 25, 2019 7:34 am

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: 1759
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski » Mon Mar 25, 2019 3:17 pm

Hello,

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

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

Re: Quetions about Dashboards.JS query

Post by aixmo » Tue Mar 26, 2019 9:32 am

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: 1759
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski » 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.
aixmo
Posts: 5
Joined: Mon Mar 25, 2019 7:19 am

Re: Quetions about Dashboards.JS query

Post by aixmo » Sat Mar 30, 2019 4:00 am

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

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski » Wed Apr 03, 2019 6:25 pm

Hello,

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

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

Re: Quetions about Dashboards.JS query

Post by aixmo » Thu Apr 04, 2019 1:23 am

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: 1759
Joined: Tue Mar 20, 2018 5:34 am

Re: Quetions about Dashboards.JS query

Post by Lech Kulikowski » Sat Apr 06, 2019 9:25 pm

Hello,

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

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

Re: Quetions about Dashboards.JS query

Post by aixmo » Wed May 22, 2019 1:56 am

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

Re: Quetions about Dashboards.JS query

Post by HighAley » Fri May 24, 2019 8:53 am

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