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

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.


mtia,

- Steve

[Back to original message]