MS Access database support - 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

Larry Linson wrote:
> "David W. Fenton" <XXXusenet@dfenton.com.invalid> wrote
>
>
> Maybe I am missing something here: I thought you had said, use a Query that
> lets the DB engine to the selection of the record or two you need to see,
> and retreive only what you need. But he, on the other had, is bound and
> determined to open the entire recordset and then locate one record of
> interest be it with Seek or with.

This was not ment to be a demonstration of coding practices. This was
ment to be a test of the relative speeds of the three methods of
retrieving a field value from a table from a specific record. In the
test, the Query with a Where clause was one of the tests along with Seek
and FindFirst.

--
Bri

Sponsored Links