SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Count number of queries
-
Nov 19, 2008, 22:07 #1
- Join Date
- Aug 2004
- Location
- philippines
- Posts
- 574
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Count number of queries
Hi guys! i have a simple question. I wanted to run a php apge that queries mysql. After the page loaded completely, how can i know ho many number of queries has been done? is there a mysql program that will show me the details of the last queries? are these report on phpmyadmin?
If you won't dress like the
Victoria Secret girls,
don't expect us to act like soap opera guys.
-
Nov 19, 2008, 22:18 #2
MySQL has logging, but unless you have access to the server you might find that difficult. I don't believe that phpMyAdmin has any way of accessing the MySQL logs.
If your program is issuing the queries, can't you record them yourself?
-
Nov 24, 2008, 19:21 #3
- Join Date
- Aug 2004
- Location
- philippines
- Posts
- 574
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
my goodness i wasnt notified of the reply, thanks fattyjules! yes i could make them count if i edit my code, its just that i wanted a quick graps of the numbers cause i wanted to check on the performance of one of my scripts..
thanks again fattyjules!If you won't dress like the
Victoria Secret girls,
don't expect us to act like soap opera guys.
Bookmarks