Reduce Code 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?

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.