[Phpmyadmin-devel] about MaxNavigationItems

[Marc Delisle]

Marc Delisle a écrit :
> Rouslan Placella a écrit :
>> On 11/09/2012 12:42 PM, Marc Delisle wrote:
>>> Hi Rouslan,
>>>
>>> The default value for this is 25. I have a situation where the page
>>> navigator appears when I have plenty of space in the panel. The reason
>>> is that one of the databases uses a prefix and there are about 20
>>> databases starting with this prefix.
>>>
>>> So, it might be difficult to understand why MaxDbList is set to 100 and
>>> I don't see 100 databases on page 1.
>> Hi Marc,
>>
>> The limit applies to how many items are fetched from MySQL before being 
>> grouped and rendered, hence the issue.
>>
>> Anyway, what if you had 1000 dbs in a group? Here, in order to be able 
>> to show the next group (or next db), we would have to fetch all 1000 dbs 
>> from the first group. The implementation of grouping at the moment is 
>> not particularly fast, so in situations like this I would expect the 
>> navigation to grind down to a halt.
> 
> Hi Rouslan,
> I tried "100" in MaxNavigationItems and saw no delay; did you have a 
> reason to put "25" in its default value?

I mean, apart from how many non-grouped dbs would be displayed?

> 
>> I've always been aware of this situation, but I just can't see any 
>> straight forward way of improving it. Sorry...
>>
>> Bye,
>> Rouslan
> 
> 
> 


-- 
Marc Delisle
http://infomarc.info