thank u lovatt!
cant i create an application that runs like a
Oracle trigger using 'C' so that i can get the queries
and the time they took to execute dynamically rather
than using a synthetic model.
--- Peter Lovatt <[EMAIL PROTECTED]> wrote: > Hi
>
> if you are using php
>
> http://uk.php.net/manual/en/function.microtime.php
>
> <?php
> function getmicrotime(){
> list($usec, $sec) = explode(" ",microtime());
> return ((float)$usec + (float)$sec);
> }
> $time_start = getmicrotime();
>
> //query here
>
> $time_end = getmicrotime();
> $time = $time_end - $time_start;
> echo "Did nothing in $time seconds";
> ?>
>
>
>
>
> -----Original Message-----
> From: Prem Soman [mailto:[EMAIL PROTECTED]
> Sent: 21 June 2003 08:03
> To: mysql groups
> Subject: Query excution time
>
>
> hi !
>
> what is the best way to find query excution time in
> MySql
>
> plz help me!
>
>
________________________________________________________________________
> Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> Messenger http://uk.messenger.yahoo.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
