[AccessD] Speed up DAO processing

	Why why why.....
	 
	Why is findfirst slower than seek...
	Does findfirst not use the indexes?
	 
	I'm sure about the multiple criteria thing in findfirst.
	I noticed huge delays when using two or more criterias on fields
both had indexes and experimeted with the compound indexes (multiple
fields in one combined index).
	So I wrote a routine with first an SQL build querie in a loop
and then findfirst loop with only one criteria.
	 
	Erwin
	 
	 
	 

		-----Original Message-----
		From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
		Sent: Thursday, September 04, 2003 4:03 PM
		To: Access Developers discussion and problem solving
		Subject: RE: [AccessD] Speed up DAO processing
		

			 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030904/66454e78/attachment-0001.html>