Recuring Query

[Chad123]

Heya,

I have a query that needs to be run several times – same query, variable data - on both an Access DB and SQL Server DB…

This being said, would it be faster to run this query as a new recordset everytime, or to open the table in a recordset and rs.Filter everytime closing the recordset once the whole process is complete?

Thanks,
Chad

 

[jebenson]

Well, I would say that depends on the amount of data returned by each query. If each query returns a large amount of data, you probably would be better off doing the Filter option. If each query returns a medium or small amount of data, running the query each time probably won't be that big of a performance hit.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson