[pgAdmin4][RM3941] Dashboard graphs needs optimizations - Mailing list pgadmin-hackers

From Aditya Toshniwal
Subject [pgAdmin4][RM3941] Dashboard graphs needs optimizations
Date
Msg-id CAM9w-_=uidEaAy=VH8VWq5YpvWSCjZFUt=WNaRt6dyhUYC6WXA@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin4][RM3941] Dashboard graphs needs optimizations
List pgadmin-hackers
Hi Hackers,

Attached is the patch to optimise the dashboard. Changes include:
1) One ajax request for the all the charts instead of separate for every chart. The next request will not hit until the previous is completed.
2) The code will check for intervals which is greatest common divisor of all the refresh rates. Chart names which will be eligible for refresh will be sent with the ajax. If none are eligible, no ajax will be fired.
3) In the backend, query is generated in such a way that data for all the requested chart names will be fetched in one hit to the database.
4) Test cases for charts rest api and javascript added.

--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"
Attachment

pgadmin-hackers by date:

Previous
From: Chethana Kumar
Date:
Subject: Re: [pgAdmin4[RM#3948] Fix backform note control style
Next
From: Khushboo Vashi
Date:
Subject: Re: [pgAdmin4][Patch]: RM - 3051 - ables > Properties > Columns tab is slow on tables with a lot of fields