#4391 (ok 4.3) Upgraded to 4.2.0, insanely slow now

[Justin]

Just upgraded to 4.2.0 from 4.1.13 and the speed is insanely slow. To render the main page (after you log in) taking greater than 15 seconds.

Is this a know bug?

[Justin]

Found the problem with SQL debugging. It is running a query per database, and in our case, we have near 5,000 databases.

[count] => 1
[query] => SELECT COUNT(*) FROM phpmyadmin.pma__navigationhiding WHERE username='root' AND db_name='act_ZxLsP5282911f0312fIiB'
[time] => 0.0005040168762207
[trace] => Array
(
[0] => Array
(
[0] => ./libraries/DatabaseInterface.class.php#206: PMA_DatabaseInterface->_dbgQuery()
[1] => ./libraries/DatabaseInterface.class.php#1564: PMA_DatabaseInterface->tryQuery()
[2] => ./libraries/navigation/Nodes/Node_Database.class.php#350: PMA_DatabaseInterface->fetchValue()
[3] => ./libraries/navigation/NavigationTree.class.php#1004: Node_Database->getHtmlForControlButtons()
[4] => ./libraries/navigation/NavigationTree.class.php#1033: PMA_NavigationTree->_renderNode()
[5] => ./libraries/navigation/NavigationTree.class.php#701: PMA_NavigationTree->_renderNode()
[6] => ./libraries/navigation/Navigation.class.php#52: PMA_NavigationTree->renderState()
[7] => ./libraries/Header.class.php#380: PMA_Navigation->getDisplay()
[8] => ./libraries/Response.class.php#262: PMA_Header->getDisplay()
[9] => ./libraries/Response.class.php#275: PMA_Response->_getDisplay()
[10] => ./libraries/Response.class.php#373: PMA_Response->_htmlResponse()
[11] => ./libraries/OutputBuffering.class.php#114: PMA_Response::response()
[12] => PMA_OutputBuffering::stop()
)

                    )

            )

[Madhura Jayaratne]

Are you testing with the development version? This issue has been fixed and
SELECT db_name, COUNT(*) AS count FROM phpmyadmin.pma__navigationhiding WHERE username='root' GROUP BY db_name
is used instead.

[freeman]

it's not fixed
only the warning about slowness appeared :)

[Marc Delisle]

freeman, care to give more details please?

[freeman]

same thing as before
i have 6000+ db
when i enable grouping, it takes 30 seconds to load the page
when i turn it off, it's faster

maybe can you make an option to group only tables not databases
i guess that would be faster
when quick db seach is fixed there's no need to group databases