<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Bericht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><BR></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>Why
why why.....</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>Why
is findfirst slower than seek...</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>Does
findfirst not use the indexes?</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>I'm
sure about the multiple criteria thing in findfirst.</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>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).</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff size=2>So I
wrote a routine with first an SQL build querie in a loop and then
findfirst loop with only one criteria.</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2>Erwin</FONT></SPAN></DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=879445315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=nl dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Jim
Dettman<BR><B>Sent:</B> Thursday, September 04, 2003 4:03 PM<BR><B>To:</B>
Access Developers discussion and problem solving<BR><B>Subject:</B> RE:
[AccessD] Speed up DAO processing<BR></FONT></DIV>
<BLOCKQUOTE> </BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>