which is faster (better)

  • Thread starter Thread starter Drew
  • Start date Start date
D

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
 
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
 
Back
Top