Re: How to get query execution time of an MS SQL Query in Visual basic

From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 09:11:13 -0400

If you are executing the query from vba, create a timer (using
GetTickcount from the Windows API or something similar). Record the
start time at the beginning of the query, and the stop time after it
completes. Compute the total time elapsed.

--Mary

On 14 Sep 2004 23:46:21 -0700, rajeevmc@yahoo.com (Rajeev M C) wrote:

>please let me know How to get query execution time of an MS SQL Query
>in Visual basic

Relevant Pages

  • Re: Periodic Time Triggering!
    ... > and the one suggested by Paul G. Tobey. ... > problem of meeting deadline (i.e. the frequency for each kind of query). ... >> and have each act as the timer func for its own timer. ...
    (microsoft.public.pocketpc.developer)
  • Re: Periodic Time Triggering!
    ... > and the one suggested by Paul G. Tobey. ... > problem of meeting deadline (i.e. the frequency for each kind of query). ... >> and have each act as the timer func for its own timer. ...
    (microsoft.public.windowsce.app.development)
  • Re: how to save info with timer
    ... I don't need to add anything to Form, like Timer Control? ... I have created query and would like it to run on certain intervals. ... Set up the OnTimer event to run the query when the Timer ... On Error GoTo err_ ...
    (microsoft.public.access.queries)
  • Re: Periodic Time Triggering!
    ... timeout =; ... > But the problem is that each query to the external resource has its own ... > class A: public CWinThread ... > With this solution I was thinking of using a Timer for each class A object ...
    (microsoft.public.pocketpc.developer)
  • Re: Periodic Time Triggering!
    ... timeout =; ... > But the problem is that each query to the external resource has its own ... > class A: public CWinThread ... > With this solution I was thinking of using a Timer for each class A object ...
    (microsoft.public.windowsce.app.development)