which is faster (better)

[Drew]

Probably the filter because of the Query Optimizer that
runs the first time an SQL or Query is run. Depending on
the length of the SQL and the size of the table, the
number of tables involved and other considerations
filtering the records would probably be fast than running
each new query through the Optimizer each time you set
it. The Optimizer is very fast, but it does take process
cycles.

The only way to see it to run a test. Do the queries
take so long to run that a second or two would make a big
difference?

Drew

 

[Adrian Jansen]

If the filter is applied to a form, then the form recordsetclone contains
just the filtered records, so you just loop through that.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control