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.