Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maybe if I change the subject header...

    I'm in the process of converting my databases.

    Is there a quick & easy way to record how long a query takes to run?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Maybe if I change the subject header...

    The short answer is "No".

    It seems to me there is some sort of logging that can be turned on that will give you information about queries when they are executed. I don't know if includes run times, and I don't even remember how to do it. Sorry.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Maybe if I change the subject header...

    Actually, it isn't too hard to do. Check out the "Timer" function in VBA - it gives you the number of seconds since midnight. The code example for it shows how to determine elapsped time. We do this to determine what kind of user response time we are getting when we open a form or go for a new record. It isn't accurate to the millisecond, but it's useful in most cases. To run the query simply use
    DoCmd.OpenQuery QueryName

    I'm curious why you ask - are you expecting performance problems when you upgrade?
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •