Results 1 to 2 of 2

Thread: Time Trials

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Youngstown, Ohio, USA
    Thanked 0 Times in 0 Posts

    Time Trials

    I'm in the final stages of developing a large data base, and the boss is interested in the time it takes to read selected data from the main database and append it into a temporary holding table (where this smaller selection will be re-queried and analyzed further). What I would like to do is have Access calculate the time it takes to run the query. I tried adding a field to the output to timestamp when each record is passed through the query and appended to the target table (using Now()), but all of the records output always ended up with the same timestamp.

    The sample data I am working with has just over 500,000 records, but is indexed on the two fields checked by the append query. This gives me decent access times, providing the database is compacted. When it is uncompacted, access times are pretty poor... To be fair, I'd need to test the times under both good and unfavourable conditions.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Time Trials

    Nothing actually gets written until the last record is processed, so I'm not surprised at the uniform time stamp.

    Have you tried executing the query from a form? You could include a button to execute the query and two textboxes. When the button is clicked, use its click event to populate textbox1 with Now(), then use something like CurrentDb.Execute "MyQuery", then populate textbox2 with Now(). The difference should be the elapsed time.

Posting Permissions

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