Re: [pgAdmin4][RM3941] Dashboard graphs needs optimizations

From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
To: Akshay Joshi <akshay(dot)joshi(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 09:02:35
Message-ID: CAFOhELdah8SNhc+eiqDUewNY21DmqrUr2FkPRyRcwPkXKNdoeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Aditya,

I have reviewed the patch and it looks good to me except the logic to wait
until we get the response from the AJAX request.
So, in this case at a time only one request is being sent to the server.

@ Dave/Ashesh, if you think this is okay then we can commit the patch.

Thanks,
Khushboo

On Mon, Feb 4, 2019 at 10:45 AM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> 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*
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2019-02-04 09:42:02 Re: [pgAdmin4][RM3941] Dashboard graphs needs optimizations
Previous Message Aditya Toshniwal 2019-02-04 08:48:37 Re: [pgAdmin4][RM3936] Feature tests failing intermittently for SQL editor related test cases