Re: [PHP] show mysql- processing time

2002-11-21 Thread Tularis
ok, let me rephrase that... I ment I would like to use a php-function for it, OR a mysql command... just not such a function as I put down here... Chris Shiflett wrote: Well, you say you want to return the processing time of a MySQL query via PHP, but then you go on to say that you do not want t

RE: [PHP] show mysql- processing time

2002-11-21 Thread Van Andel, Robert
Sorry, I didn't read the entire message. Didn't realize you were already using my suggestion. Robbert van Andel -Original Message- From: Tularis [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 8:28 AM To: [EMAIL PROTECTED] Subject: [PHP] show mysql- processing time I was

RE: [PHP] show mysql- processing time

2002-11-21 Thread Van Andel, Robert
This is what I did. $StartTime = date("U"); $result = mysql_query($query); $EndTime = date("U"); $difference = $EndTime - $StartTime; echo "The query took $difference seconds to generate\n"; Perhaps not the most accurate but who cares about a few milliseconds. Robbert van Andel -Original

Re: [PHP] show mysql- processing time

2002-11-21 Thread Chris Shiflett
Well, you say you want to return the processing time of a MySQL query via PHP, but then you go on to say that you do not want to do this in PHP. :-) I would recommend Jeremy Zawodny's mytop: http://jeremy.zawodny.com/mysql/mytop/ Chris --- Tularis <[EMAIL PROTECTED]> wrote: > I was wondering if