#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Virginia Beach, Virginia
    Posts
    7
    Rep Power
    0
    Is it possible to find out how long a query takes? I'm using PHP/MySQL.

    Any advice?

    ------------------
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    I know from the command line, MySQL will tell you how long the query took, but I've never seen any way to access that value from PHP/MySQL. That'd be nice to have, though.


    You could do it the long way by finding the time before the query, then right after. It wouldn't be exact, but could be close enough to work.

    ---John Holmes...

Similar Threads

  1. Replies: 4
    Last Post: February 27th, 2004, 04:06 PM
  2. Replies: 3
    Last Post: January 29th, 2004, 10:12 PM
  3. query data at the same time
    By dbosz in forum PHP Development
    Replies: 2
    Last Post: January 19th, 2004, 09:04 PM
  4. Replies: 2
    Last Post: January 19th, 2004, 03:26 AM
  5. Replies: 0
    Last Post: January 14th, 2004, 07:01 AM

IMN logo majestic logo threadwatch logo seochat tools logo