Equality (=) Operation Very Expensive in MS Access 2007 - August 31, 2009
I was doing some Access 2007 debugging for a client today and a search using a form was taking close to 10 minutes. Even with a half million records, this seemed horribly slow for Access. Changing the query from (year = 2007 or year = 2008 or year = 2009) to (year < 2006) made the 10 minute search turn into a 2 second search. Apparently testing for equality with Access is terribly expensive in terms of process time.