Stuart McLachlan
stuart at lexacorp.com.pg
Wed Oct 15 17:16:21 CDT 2003
On 15 Oct 2003 at 14:46, Heenan, Lambert wrote: > NumericSearchStart = Timer > .FindFirst sCriteria > intHits = intHits + Abs(CLng(Not .NoMatch)) > NumericSearchEnd = Timer ... > TextSearchStart = Timer > .FindFirst sCriteria > strHits = strHits + Abs(CLng(Not .NoMatch)) > TextSearchEnd = Timer .... > > And here are the results of a few runs, last to first... > Average find times Numbers:0.0020859370 Hits:0 Strings:0.0025468750 Hits:0 The results are meaningless :-( Timer is only accurate to about 1/18th of a second ie to .0556 seconds. Any test which takes less than that will either return 0 or .0556. You are carrying out a single indexed lookup on an open table plus a calculation using 5 functions (addition, Abs() CLng(), negation, NoMatch) Which do *you* think takes longer (ie has most effect on your results)? -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.