Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why does phpMyAdmin take a long time to display a query, yet shows that the query executed fast? [closed]

I'm tying to execute a query in phpMyAdmin. The query takes approximately two minutes to load, but at the top of the query results it says that the "Query took 0.2768 sec". How is this possible?

like image 465
Jack7890 Avatar asked Jul 31 '09 23:07

Jack7890


1 Answers

The larger your resultset, the slower phpMyAdmin is. The phpMyAdmin script receives the query result from MySQL in 0.2768 seconds. It then must parse the thousands of rows/columns of data in this and apply all the markup necessary to display it in your browser. This eats up time, and memory. I suggest using a command-line client if speed is a concern.

like image 175
hobodave Avatar answered Oct 13 '22 01:10

hobodave