My code is very large it takes an hour to finish running, any tips to reduce the runtime ?
My code is very large it takes an hour to finish running, any tips to reduce the runtime ?
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
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.