Consulting

Results 1 to 3 of 3

Thread: Reduce Code Runtime

  1. #1

    Reduce Code Runtime

    My code is very large it takes an hour to finish running, any tips to reduce the runtime ?

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,999
    Location
    Without seeing the code its hard to determine just exactly you are talking about. Can you upload a small section?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    try a Query instead of recordset, it is much faster.
    index your tables on related fields.
    if you are employing FE/BE, try adding a persistent
    connection to the backend.

Posting Permissions

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