Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
timing sql query
- Thread starter insania
- Start date
D.E.R. Management - IT Project Management Consulting
As part of my development process I print the sql command to the browser that I'm executing. I also print out the mysql_errno() and mysql_error(). This shows me exactly what the MySql Server received and the results were.
I've found that if I copy the sql from the browser and put it in the SQL box for PHPMyAdmin to execute the query. This not only gives me the test results but gives you a time that the execution took.
Hope this helps!
Peace
"If the only prayer you said in
your whole life was, 'thank you,'
that would suffice."
-- Meister Eckhart
I've found that if I copy the sql from the browser and put it in the SQL box for PHPMyAdmin to execute the query. This not only gives me the test results but gives you a time that the execution took.
Hope this helps!
Peace
"If the only prayer you said in
your whole life was, 'thank you,'
that would suffice."
-- Meister Eckhart
- Status