RE: Query excution time

2003-06-23 Thread Prem Soman
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

RE: Query excution time

2003-06-21 Thread Chris Knight
Can you run it from the client and see how long it tells you it takes? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Saturday, June 21, 2003 10:52 AM To: Prem Soman Cc: mysql groups Subject: Re: Query excution time On Sat, Jun 21, 2003 at 08:02:42AM +0100

Re: Query excution time

2003-06-21 Thread Jeremy Zawodny
On Sat, Jun 21, 2003 at 08:02:42AM +0100, Prem Soman wrote: > hi ! > > what is the best way to find query excution time in > MySql Ususally, I do the timing in my application(s). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.za

Re: Query excution time

2003-06-21 Thread Tobias Schittkowski
If you want a simple solution for windows, check RSSmyperfmon www.rss-software.de/en > MTop (MySQL Top) is a really nice little utility: > http://mtop.sourceforge.net/ > > Shows what queries are running, and elapsed time. > > Daivd > - Original Message - > From: "Prem Soman" <[EMAIL PROTEC

Re: Query excution time

2003-06-21 Thread David Griffiths
MTop (MySQL Top) is a really nice little utility: http://mtop.sourceforge.net/ Shows what queries are running, and elapsed time. Daivd - Original Message - From: "Prem Soman" <[EMAIL PROTECTED]> To: "mysql groups" <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 12:02 AM Subject: Query e