Re: [Phpmyadmin-devel] Any last wishes?
Resending to devlist... On Mon, Aug 15, 2011 at 3:53 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Mon, Aug 15, 2011 at 11:19 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
what I would like to see:
- improve page load speed, currently it takes quite long till tabs are initialized
- Do you have any knowledge about js/config.js? It doesn't look like it's needed on the status page at all. Maybe we could include this file only where it's needed.
- I could load the status variables on demand (when the user clicks the tab), I guess that would be the next best speed improvement.
Apart from these two optimizations I'm not sure whether there's anything left to optimize that would result in big loading speed improvements. Well I could also load the query statistics on demand. But having almost every tab load on demand only shifts the loading time to a later point.
Also I'm not sure whether it's really necessary for the status page to load so quick. Each tab has some sort of refresh functionality so you never have to fully reload the page anyway.
- automatically start monitor when switching to monitor tab
I'm also not so sure about this. The Monitor adds some overhead to the mysql server as well as to your client browser, through the regular refreshes. Having it start automatically it will be more likely that people will have the monitor running without actually needing it.
Though, I do agree that showing an empty page instead isn't very nice either.
-- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
Hi Dne Mon, 15 Aug 2011 15:54:18 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
Resending to devlist...
On Mon, Aug 15, 2011 at 3:53 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Mon, Aug 15, 2011 at 11:19 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
what I would like to see:
- improve page load speed, currently it takes quite long till tabs are initialized
- Do you have any knowledge about js/config.js? It doesn't look like it's needed on the status page at all. Maybe we could include this file only where it's needed.
Yes, it does check if user has saved configuration in local browser storage and if he does, asks if he wants to load it.
- I could load the status variables on demand (when the user clicks the tab), I guess that would be the next best speed improvement.
Apart from these two optimizations I'm not sure whether there's anything left to optimize that would result in big loading speed improvements. Well I could also load the query statistics on demand. But having almost every tab load on demand only shifts the loading time to a later point.
I don't think loading of the code is the problem here - all files load in about half second, while the jQuery tabs are initialized in around five seconds. Not sure what is happening in meantime.
Also I'm not sure whether it's really necessary for the status page to load so quick. Each tab has some sort of refresh functionality so you never have to fully reload the page anyway.
- automatically start monitor when switching to monitor tab
I'm also not so sure about this. The Monitor adds some overhead to the mysql server as well as to your client browser, through the regular refreshes. Having it start automatically it will be more likely that people will have the monitor running without actually needing it.
Though, I do agree that showing an empty page instead isn't very nice either.
That's exactly what I don't like about it. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
Tyron Madlener a écrit : > Resending to devlist... > > On Mon, Aug 15, 2011 at 3:53 PM, Tyron Madlener <tyronx@gmail.com> wrote: >> On Mon, Aug 15, 2011 at 11:19 AM, Michal Čihař <michal@cihar.com> wrote: >>> Hi >>> >>> what I would like to see: >>> >>> - improve page load speed, currently it takes quite long till tabs are >>> initialized >> - Do you have any knowledge about js/config.js? It doesn't look like >> it's needed on the status page at all. Maybe we could include this >> file only where it's needed. >> >> - I could load the status variables on demand (when the user clicks >> the tab), I guess that would be the next best speed improvement. >> >> Apart from these two optimizations I'm not sure whether there's >> anything left to optimize that would result in big loading speed >> improvements. Well I could also load the query statistics on demand. >> But having almost every tab load on demand only shifts the loading >> time to a later point. >> >> Also I'm not sure whether it's really necessary for the status page to >> load so quick. Each tab has some sort of refresh functionality so you >> never have to fully reload the page anyway. >> >>> - automatically start monitor when switching to monitor tab >>> >> I'm also not so sure about this. The Monitor adds some overhead to the >> mysql server as well as to your client browser, through the regular >> refreshes. >> Having it start automatically it will be more likely that people will >> have the monitor running without actually needing it. No, because the person clicked "Monitor" and would see - the graphics changing - a "Pause monitor" link >> >> Though, I do agree that showing an empty page instead isn't very nice either. -- Marc Delisle http://infomarc.info
On Mon, Aug 15, 2011 at 6:48 PM, Marc Delisle <marc@infomarc.info> wrote: > Tyron Madlener a écrit : >> Resending to devlist... >> >> On Mon, Aug 15, 2011 at 3:53 PM, Tyron Madlener <tyronx@gmail.com> wrote: >>> On Mon, Aug 15, 2011 at 11:19 AM, Michal Čihař <michal@cihar.com> wrote: >>>> Hi >>>> >>>> what I would like to see: >>>> >>>> - improve page load speed, currently it takes quite long till tabs are >>>> initialized >>> - Do you have any knowledge about js/config.js? It doesn't look like >>> it's needed on the status page at all. Maybe we could include this >>> file only where it's needed. >>> >>> - I could load the status variables on demand (when the user clicks >>> the tab), I guess that would be the next best speed improvement. >>> >>> Apart from these two optimizations I'm not sure whether there's >>> anything left to optimize that would result in big loading speed >>> improvements. Well I could also load the query statistics on demand. >>> But having almost every tab load on demand only shifts the loading >>> time to a later point. >>> >>> Also I'm not sure whether it's really necessary for the status page to >>> load so quick. Each tab has some sort of refresh functionality so you >>> never have to fully reload the page anyway. >>> >>>> - automatically start monitor when switching to monitor tab >>>> >>> I'm also not so sure about this. The Monitor adds some overhead to the >>> mysql server as well as to your client browser, through the regular >>> refreshes. >>> Having it start automatically it will be more likely that people will >>> have the monitor running without actually needing it. > > No, because the person clicked "Monitor" and would see > - the graphics changing > - a "Pause monitor" link > The 'Pause monitor' link doesn't actually stop loading data. It just stops the refreshing of the charts. Once you click resume, you still have a continuous series of data in the time you paused the chart. I made it this way so one select a time range without being disturbed by the constant chart refreshes, but still has the monitor keep recording data for further analysis. Nonetheless, I've pushed a change to my repos now, that loads the monitor once the user clicks on the tab. >>> >>> Though, I do agree that showing an empty page instead isn't very nice either. > > > -- > Marc Delisle > http://infomarc.info > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > _______________________________________________ > Phpmyadmin-devel mailing list > Phpmyadmin-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel >
Le 2011-08-16 06:18, Tyron Madlener a écrit : > On Mon, Aug 15, 2011 at 6:48 PM, Marc Delisle <marc@infomarc.info> wrote: >> Tyron Madlener a écrit : >>> Resending to devlist... >>> >>> On Mon, Aug 15, 2011 at 3:53 PM, Tyron Madlener <tyronx@gmail.com> wrote: >>>> On Mon, Aug 15, 2011 at 11:19 AM, Michal Čihař <michal@cihar.com> wrote: >>>>> Hi >>>>> >>>>> what I would like to see: >>>>> >>>>> - improve page load speed, currently it takes quite long till tabs are >>>>> initialized >>>> - Do you have any knowledge about js/config.js? It doesn't look like >>>> it's needed on the status page at all. Maybe we could include this >>>> file only where it's needed. >>>> >>>> - I could load the status variables on demand (when the user clicks >>>> the tab), I guess that would be the next best speed improvement. >>>> >>>> Apart from these two optimizations I'm not sure whether there's >>>> anything left to optimize that would result in big loading speed >>>> improvements. Well I could also load the query statistics on demand. >>>> But having almost every tab load on demand only shifts the loading >>>> time to a later point. >>>> >>>> Also I'm not sure whether it's really necessary for the status page to >>>> load so quick. Each tab has some sort of refresh functionality so you >>>> never have to fully reload the page anyway. >>>> >>>>> - automatically start monitor when switching to monitor tab >>>>> >>>> I'm also not so sure about this. The Monitor adds some overhead to the >>>> mysql server as well as to your client browser, through the regular >>>> refreshes. >>>> Having it start automatically it will be more likely that people will >>>> have the monitor running without actually needing it. >> >> No, because the person clicked "Monitor" and would see >> - the graphics changing >> - a "Pause monitor" link >> > > The 'Pause monitor' link doesn't actually stop loading data. It just > stops the refreshing of the charts. Once you click resume, you still > have a continuous series of data in the time you paused the chart. > I made it this way so one select a time range without being disturbed > by the constant chart refreshes, but still has the monitor keep > recording data for further analysis. So maybe these links should be Pause display Resume display because "pause monitor" could mean also that gathering data stops. > > Nonetheless, I've pushed a change to my repos now, that loads the > monitor once the user clicks on the tab. Thanks. > >>>> >>>> Though, I do agree that showing an empty page instead isn't very nice either. >> >> >> -- >> Marc Delisle >> http://infomarc.info >> >> ------------------------------------------------------------------------------ >> uberSVN's rich system and user administration capabilities and model >> configuration take the hassle out of deploying and managing Subversion and >> the tools developers use with it. Learn more about uberSVN and get a free >> download at: http://p.sf.net/sfu/wandisco-dev2dev >> _______________________________________________ >> Phpmyadmin-devel mailing list >> Phpmyadmin-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel >> > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > _______________________________________________ > Phpmyadmin-devel mailing list > Phpmyadmin-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel -- Marc Delisle http://infomarc.info
participants (3)
-
Marc Delisle -
Michal Čihař -
Tyron Madlener