[Phpmyadmin-devel] Navigation tree problems

[Marc Delisle]

Michal Čihař a écrit :
> Hi
> 
> Dne Tue, 27 Aug 2013 08:29:04 -0400
> Marc Delisle <marc at infomarc.info> napsal(a):
> 
>> Michal Čihař a écrit :
>>> Hi all
>>>
>>> I've looked a bit about problems people see with navigation frame and
>>> here is a little summary.
>>>
>>> - Speed
>>>
>>> The navigation panel is quite slow. By quickly looking at SQL queries
>>> it does, the database/table comments are quite big culprit here. Simply
>>> setting $cfg['ShowTooltip'] = false reduces load time a lot.
>>>
>>> For not so big database (~25 tables), I get from 1.25s to 0.128s.
>>>
>>> Are tooltips really worth of this? I suggest to drop this feature
>>> completely. In case there will be demand for something like that, lets
>>> load it on demand when user is hovering the table.
>>>
>>> https://github.com/phpmyadmin/phpmyadmin/pull/646
>> As I wrote in the pull request, I suggest instead to set the directive 
>> to false by default, keeping the feature for those who need it. At least 
>> for 4.0.x.
> 
> IMHO it makes navigation simply too slow to even provide option to
> enable it. The problem is that there is probably no way to get table
> comment fast - either you use information_schema, which is usually slow
> for large databases (and therefore we do not use it by default) or SHOW
> TABLE STATUS which is on normal installations even slower than
> information_schema.

OK then. Merged to QA_4_0 and I'm working to merge it to master.

> 
>>> - Preserving state on reload
>>>
>>> This has been already discussed before.
>> Kasun is working on that this week and maybe he should target QA_4_0 for 
>> this "feature" (if it's not too much new code)?
> 
> I agree this should go into 4.0.x.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> Introducing Performance Central, a new site from SourceForge and 
> AppDynamics. Performance Central is your source for news, insights, 
> analysis and resources for efficient Application Performance Management. 
> Visit us today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


-- 
Marc Delisle
http://infomarc.info