Home > Archive > MS Access database support > April 2006 > Re: Trouble with DAO "SEEK" in converting application to SQL Express









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Trouble with DAO "SEEK" in converting application to SQL Express
Bri

2006-04-07, 8:27 pm


david epsom dot com dot au wrote:
> Just a note: you get far better results on FindFirst if your
> data fits into the Jet Cache. Finding to the end of the
> recordset is always slow (they say it uses the index some
> how, but it is hard to believe), but finding when it means
> flushing the index each time is very slow.

See the post to David I did earlier. I ran the test in a variety of
different scenarios (different table sizes, different field type for
index). The changes to Seek and the Query were minimal. The changes to
the timing of FindFirst seem to indicate that it does not use the Index
at all.

--
Bri

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com