Posted by Steve on 11/02/05 11:02

In article <3sr7tgFpded6U1@individual.net>, user@example.net (J.O. Aho)
wrote:

> *Subject:* Re: PHP/MySQL query time
> *From:* "J.O. Aho" <user@example.net>
> *Date:* Wed, 02 Nov 2005 08:28:10 +0100
>
> Steve wrote:
> > PHP/MySQL query - time taken.
> > MySQL reports how long each query takes, is this available to PHP,
> > because if it is, it's not documented in the book I have, or I
> > don't know what I'm looking for.
> >
> > I would like to play with some LIKE queries, but would like to know
> > how much they slow the query down by.
> >
> >
> > If you go to the command line client.
> >
> > From a dos box.
> >
> > login to MySQL,
> >
> > 'Use databasename'
> >
> > 'SELECT * from tablename'
> >
> > it shows the tabulated results and underneath it shows...
> >
> > xxx rows in set <0.yy sec>
> >
> > '0.yy sec' is the value I'm after.
>
> Take a look at mysql_info, should be able to give you the time as it
> can get
> other data.
>
> //Aho
>
Seemingly not, it returns a NULL for a SELECT.
http://dev.mysql.com/doc/refman/5.0/en/mysql-info.html as I read it
states that it's for INSERT, LOAD, ALTER and UPDATE's. Which certainly
goes along with what I'm seeing.


- Steve

[Back to original message]