You are here: PHP/MySQL query time « PHP SQL « IT news, forums, messages
PHP/MySQL query time

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация