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


Wayne Gillespie wrote:
>
> There is something wrong with your data as I get nothing like the speed drop you
> experience with FindFirst.

Keep in mind that the Seek and the Query are in a loop running 1000
times while the FindFirst is only running ONCE.

> However in all versions of Access the order of performance (using your test) is
> Seek then FindFirst then Query.
>
> Access97
> ==========
> Seek (1000) - 0.171875
> Query (1000) - 0.53125
> Open rs - 0
> FindFirst - 0.21875
> FindFirst finish - 0.21875

Thank you for running the test in the different versions of Access. It
shows that the version is not making a significant difference to the test.

--
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