Re: [PHP] Getting MySQL Query Times.

2001-08-23 Thread David Robley
On Fri, 24 Aug 2001 01:52, Gabe da Silveira wrote: > 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 shel

Re: [PHP] Getting MySQL Query Times.

2001-08-23 Thread Andrey Hristov
ou 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. > > Nathan Cook > [EMAIL PROTECTED] > - Original Message - > From: "Gabe da Silveira" <[EMAIL PROTECTED]&g

Re: [PHP] Getting MySQL Query Times.

2001-08-23 Thread Gabe da Silveira
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

RE: [PHP] Getting MySQL Query Times.

2001-08-23 Thread Jon Haworth
> 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 > g

Re: [PHP] Getting MySQL Query Times.

2001-08-23 Thread Nathan Cook
idea of processing time. Nathan Cook [EMAIL PROTECTED] - Original Message - From: "Gabe da Silveira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 10:22 AM Subject: [PHP] Getting MySQL Query Times. > I was looking thru the mysql fun

Re: [PHP] Getting MySQL Query Times.

2001-08-23 Thread Andrey Hristov
the reported time can be negative. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: "Gabe da Silveira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 7:22 PM Subject: [PHP] Getting MySQL Query Tim

[PHP] Getting MySQL Query Times.

2001-08-23 Thread Gabe da Silveira
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