| From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
|---|---|
| To: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
| Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: [pgAdmin4][RM3941] Dashboard graphs needs optimizations |
| Date: | 2019-02-04 05:15:36 |
| Message-ID: | CANxoLDfDJayFiSpsBf+nFW74c5VOsNgsDKfRTrLaCQe=MDOuwg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Hi Khushboo
Can you please review it.
On Fri, Feb 1, 2019 at 7:04 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> 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"
>
--
*Akshay Joshi*
*Sr. Software Architect *
*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Akshay Joshi | 2019-02-04 06:02:55 | pgAdmin 4 commit: Replace Bootstrap switch with Bootstrap4 toggle to im |
| Previous 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 |