Posted by J.O. Aho on 11/02/05 09:28

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

[Back to original message]