
27 Aug
2013
27 Aug
'13
12:28 p.m.
On Tue, Aug 27, 2013 at 2:45 PM, Michal Čihař <michal@cihar.com> wrote: > 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 > > - Pagination > > Pagination together with tree can be quite annoying. I think we should > increase limit for pagination to something like 250. It is still not > too much to load (with disabled table comments, see above) and you can > scroll in the navigation bar, what is much more convenient that > clicking browse arrows. > > https://github.com/phpmyadmin/phpmyadmin/pull/647 > > +1 to the speed and pagination improvements... > - Quick search and pagination > > "%s other result found" is another usability nightmare, but this can be > hidden by increasing limits (see above). But IMHO quick search (as it > is anyway server side) should directly return all results. > > - Database jumping > > Maybe we should consider some option for database jumping - providing > select box with all databases which will bring user directly to this > database. This seems to be quite frequent use case for people > maintaining lot of databases and tree navigation makes this quite > hard... > > I think fast-filter feature may also be more handy for quickly jumping databases:- - If we set the cursor focus by default on fast-filter feature when the user is in navi panel, (after removing "%s other result found" thing). This way user can just start typing a few characters in the name of the database.. Also, we could dynamically adjust the current "minimum 30 databases" limit on fast-filter feature, to enable fast-filter whenever the databases list is long enough that it goes down below the visible page height.. -- Atul Pratap Singh http://blog.atulsisodia.in/