Use microtime before and after the query.
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.
----- Original Message -----
From: "Gabe da Silveira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
> wFone: (612)624-7270
> eMail: [EMAIL PROTECTED]
> hPage: http://www.visi.com/~jiblet
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]