[Phpmyadmin-devel] Performance improvements for servers having large number of databases
madhura.cj at gmail.com
Mon Nov 3 19:31:59 CET 2014
On Mon, Nov 3, 2014 at 10:08 AM, Marc Delisle <marc at infomarc.info> wrote:
> Madhura Jayaratne a écrit :
> > Hi all,
> > Today morning I spent some time testing the performance improvements that
> > were done for the servers having a large number of databases.
> > My setup has about 5000 databases grouped in to database groups of 20
> > databases. Navigation items at first level  is limited to 50 meaning
> > that about 1000 databases are loaded in the initial page of navigation.
> > While loading the initial page,
> > QA_4_2: 1008 queries executed 1011 times in 1.00407 s
> > master: 12 queries executed 17 times in 0.51211s
> > Even though master is about 2 times faster in terms of the query
> > time, the overall time to load the page is dominated by the time taken to
> > render 1000 nodes in navigation, which is about 8s for master and 11s for
> > QA_4_2.
> > However the rendering time can be significantly improved by setting 
> > a lower value, which currently defaults to 250. If I remember right, this
> > directive was set to a higher value to prevent navigation from having
> > spaces below . Since this issue is no longer there (now when  is
> > to, say 50, 50 databases or database groups are displayed) I suggest to
> >  to a lower value.
> > 
> >  https://sourceforge.net/p/phpmyadmin/mailman/message/30077320/
> Hi Madhura,
> Good idea.
I've set this to 25, which seemed to fit to the screen without showing
Thanks and Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers