Re: Getting MySQL Query Times.

Use microtime before and after the query. $this->starttime=explode(' ',microtime()); // query() $this->endtime=explode(' ',microtime()); $this->starttime=$this->starttime[1]+$this->starttime[0]; $this->endtime=$this->endtime[1]+$this->endtime[0]; $this->parse_time=$this->endtime-$this->starttime; I've copied from working code of a class. But the idea is clear.This way is better than time() solutuion because with microtime() you get microseconds. But have in mind that on windows there are some problems with microtime() and the reported time can be negative. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% ----- Original Message ----- From: "Gabe da Silveira" <jiblet@visi.com> To: <php-general@lists.php.net> Sent: Thursday, August 23, 2001 7:22 PM Subject: [PHP] Getting MySQL Query Times. > I was looking thru the mysql functions, and there doesn't seem to be one > that gives you the amount of time a query takes. Is there anyway to get > this information (since it gives it to you when you type queries > directly into the mysql shell client)? A script of mine is starting to > get fairly slow (2-3 seconds for page to process) and I want to be able > to log the query speeds so I can see if there's a database bottleneck or > if my code is just kludgy. > > -- > __________________________________ > Gabe da Silveira, Web Designer > Twin Cities Student Unions > University of Minnesota > http://www.coffman.umn.edu > > wFone: (612)624-7270 > eMail: jiblet@visi.com > hPage: http://www.visi.com/~jiblet > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >