[Phpmyadmin-devel] about MaxNavigationItems

[Rouslan Placella]

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.

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

Bye,
Rouslan