Terry Kreft wrote:
"David" <da***@adrenasys.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
>We're using Access 2003 as a front end for a SQL Server database.
When opening a linked table in Access, why is there such a huge speed
difference in Filtering by a value and doing an Edit->Find
You don't say which you are finding the faster, but I would expect,
all things being equal that a filter would be faster than a find.
The reason being that a filter is a set based operation whereas a
find is a cursor based operation.
My experience when working against ODBC links to SQL Server that FIND is so
slow as to be unusable. I assume it pulls the data over so it can be
scanned in Access locally. Filters on the other hand pass perfectly concise
SQL statements to the server and respond very fast.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com