View the Most Wanted LQ Wiki articles.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 06-26-2004, 11:44 AM   #1
Registered: Jul 2002
Location: Davie, FL
Distribution: Debian
Posts: 33

Rep: Reputation: 15
SQL queries per page (PHP, MySQL)

i'm busy doing doing some stats for my project (php,mysql) and was wondering about how many queries i have done per page rendered. Any idea how i would go about doing this? Is there some mysql query i can do that'll just tell me this? Thanks
Old 06-26-2004, 02:24 PM   #2
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 65
There isn't a php function to do it but you could create your own function and always use it to run queries then you can keep track of them quite easily.
Old 06-27-2004, 11:15 PM   #3
Registered: May 2004
Location: AUCKLAND
Distribution: Fedora core 2 , RH9
Posts: 64

Rep: Reputation: 15
i remember seeing in mysqld a status report of how many querys were done.. but i think it gets reseted after you restart it.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
seaching by SQL queries jonaskoelker LQ Suggestions & Feedback 6 05-27-2005 09:52 AM
Security risks of php based mysql queries TigerOC Linux - Security 5 04-10-2005 07:30 AM
SQL mySQL PHP and Sessions poeta_boy Programming 15 11-26-2003 06:36 PM
JSP: sql queries markus1982 Programming 0 11-05-2003 05:20 AM
php post data sql queries... bulliver Programming 2 01-03-2003 02:18 AM

All times are GMT -5. The time now is 09:22 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration