MySQL: command line vs phpMyAdmin

Question

I noticed that if I run queries with large queries, such as complex SELECT or REPAIR TABLE , I get much faster results if I use the command line and not phpMyAdmin. However, evaluating the graphical interface, I wandered if using exec to send a query directly to MySQL would speed up the shutdown time and why.

Answer 1

phpMyAdmin is very bloated. The command line interacts directly with the database. You might want to exchange, if possible, another client.