Re: Query execution time - MySQL

2008-05-14 Thread Eric Frazier
Neil Tompkins wrote: Thanks for your help. In the end I've decided to use GetTickCount() Neil Date: Wed, 14 May 2008 13:44:22 +0100> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Query execution time - MySQL> > Hi Neil,

RE: Query execution time - MySQL

2008-05-14 Thread Neil Tompkins
Thanks for your help. In the end I've decided to use GetTickCount() Neil > Date: Wed, 14 May 2008 13:44:22 +0100> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Query execution time - > MySQL> > Hi Neil,> >

RE: Query execution time - MySQL

2008-05-14 Thread Neil Tompkins
]> CC: mysql@lists.mysql.com> Subject: Re: Query execution time - > MySQL> > Hi Neil,> > If your using Linux then you have to install the glib > RPM's in the usual > way. I don't know about other platforms, but I am sure > there will be a > version of glib

Re: Query execution time - MySQL

2008-05-14 Thread Ben Clewett
9:09 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: Re: Query execution time - MySQL > > If you using C++ then you can use this: > > http://developer.gimp.org/api/2.0/glib/glib-Timers.html >

Re: Query execution time - MySQL

2008-05-14 Thread Ben Clewett
If you using C++ then you can use this: http://developer.gimp.org/api/2.0/glib/glib-Timers.html I use this in my code, does an excelent job. Also you may want to look at the 'slow log' in mysql which will show, to the nearest second, the length of queries Ben Neil Tompkins wrote: Hi Cr

RE: Query execution time - MySQL

2008-05-14 Thread Neil Tompkins
Hi Craig, Thanks for your detailed reply. Basically what I'm trying to extract is the time taken from when I execute the mysql query in my C++ Builder program until the time the query has finished. So my question is can I build in to my SQL query SELECT Name FROM Customers the time the quer

Re: Query execution time - MySQL

2008-05-14 Thread Craig Huffstetler
Greetings Niel, Not much detail there (but I'll go off what you provided...). Some people limit the actual MySQL system for times it TAKES MySQL to execute queries. For THIS to be accomplished, MySQL has built-in functionality to measure the time is takes queries to take place so it can ... limit