How to disable or bypass phpmyadmin SQL_CALC_FOUND_ROWS

Question

When you process SELECTthrough phpmyadmin, behind the scenes, it sometimes adds LIMIT 0,30, and / or it will throw SQL_CALC_FOUND_ROWSin SELECTso that it can tell me how many results would be without LIMIT.

Unfortunately, adding SQL_CALC_FOUND_ROWSsometimes requires much more processing than I expected (i.e. more than if I used my original unoccupied request).

Is there a global configuration option to disable the phpmyadmin modification of my requests?

What tricks can I use for each request to prevent phpmyadmin from being modified?

Answer 1

PHPMyAdmin , .

, sql.php else // n o t " j u s t b r o w s i n g ". // end else "just browsing" - $unlim_num_rows = 1000000;, , .

( , PMA, , , )