Re: Getting MySQL Query Times.
| From: | Gabe da Silveira | Date: | Thu, 23 Aug 2001 17:23:00 +0000 |
| Subject: | Re: Getting MySQL Query Times. | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64141@lists.php.net to get a copy of this message | ||
Thank you Andrey & Nathan. THat was probably going to be the next thing
to research. I think I figured out why my code got slow though. I have
a preg search of a large field with .* in it at the beginning of an
if,elseif,elseif,elseif struct that I should move to the end of it.
In article <007601c12bf4$e0b41f40$a300000a@pcsedu.com>,
security@pcsedu.com (Nathan Cook) wrote:
> IMO, you are better off printing microtime
> [http://www.php.net/manual/en/function.microtime.php] before and after the
> query, and after you loop through it. This will give you a better idea of
> where
> the hangups may be. You may also want to sprinkle mircotimes throughout your
> code to get a good idea of processing time.
In article <047c01c12bf3$bdae2b40$0b01a8c0@ANDreY>,
ahristov@icygen.com (Andrey Hristov) wrote:
> Use microtime before and after the query.
--
__________________________________
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