[AccessD] Number vs text data type

On 16 Oct 2003 at 10:22, Heenan, Lambert wrote:

  
> My simple demo code looks up data in half a million records and it plainly
> demonstrates that with an index it's quite fast, and without an index it's
> slow as a cow swimming in a treacle-filled pool. So where does that make the
> results meaningless? Now if you want to argue about whether .findfirst takes
> 0.05 seconds, or 0.04 or 0.0001 seconds then of course my code is not going
> to answer the question. It was about index versus non-indexed searches,
> that's all.
> 

Sorry, I thought that you were comparing numeric v text , not indexed 
v index.  

After all, that is the Subject of the email and you did say:

"As for searching for string vs numbers. Here are some results on a 
test Db I threw together."

Followed by
"But the main point is that at worst it took just about twice as long 
to search for the string as it did to find the long. Not *such* as 
huge performance hit considering we are talking about thousandths of 
a second."

In terms of your "main point", I repeat - the results were 
meaningless.  You were using Timer to measure the duration of 
operations taking "thousandths of a second" and where most of the 
operations within the loop were not related to the search.







 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.