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?
views:
273answers:
2
+3
Q:
Why does phpMyAdmin take a long time to display a query, yet shows that the query executed fast?
A:
The query executed fast, but phpMyAdmin took a long time to load it.
McWafflestix
2009-07-31 23:24:36
Right, but why would that happen? For other queries there doesn't seem to be a disconnect between phpMyAdmin load time and the query execution time, so my phpMyAdmin isn't systematically slow. It's something about this query.
Jack7890
2009-07-31 23:27:30
+4
A:
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.
hobodave
2009-08-01 00:03:15