[AccessD] Number vs text data type

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.





More information about the AccessD mailing list