Hi,
When performing a SQL query like SELECT Name FROM Customers. How do I obtain
the time in which the query took to execute like 1.5 seconds etc
Thanks,
Neil
_
All new Live Search at Live.com
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
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
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
: [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
I use this in my code, does an excelent job.
Also you
@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 out there... Also ensure the correct
include and link directives
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, If your using Linux then you have to install
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, If your using Linux then you