my question is
that is it better to open a recorset with select * from table name
and then filter it based on our requirements
or
open the recordset each time with the required condition.

any ideas or thoughts on this