Re: [pgAdmin4][RM3941] Dashboard graphs needs optimizations - Mailing 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"