[pgAdmin4][RM3941] Dashboard graphs needs optimizations

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [pgAdmin4][RM3941] Dashboard graphs needs optimizations
Date: 2019-02-01 13:33:47
Message-ID: CAM9w-_=uidEaAy=VH8VWq5YpvWSCjZFUt=WNaRt6dyhUYC6WXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
RM3941.patch application/octet-stream 39.8 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Khushboo Vashi 2019-02-04 04:48:28 Re: [pgAdmin4][Patch]: RM - 3051 - ables > Properties > Columns tab is slow on tables with a lot of fields
Previous Message Chethana Kumar 2019-02-01 13:23:03 Re: [pgAdmin4[RM#3948] Fix backform note control style