Prev: opening access2003 from access97
Next: A2010. Can be accessed by phone?
From: David W. Fenton on 29 Jul 2010 18:21
"Phil" <phil(a)stantonfamily.co.uk> wrote in
news:MdqdnZxJQqtlBs3RnZ2dnUVZ8mOdnZ2d(a)brightview.co.uk:

> I always use Elookup instead of Dlookup as well as EMax, EMin etc.
> I tried to test the difference in speed in AK2 some time ago and
> found very little difference. Almost certainly wrong, but could
> this be a myth?

In A97, the domain lookup and domain aggregate functions were much
slower on linked tables, but that was fixed starting in A2000. The
hand-rolled replacement functions for them (such as Trevor Best's
t-functions, the versions I've always used, and have extended myself
in ways that make them more versatile than the built-in Access
functions, though they are no faster now) are really no longer
necessary for performance reasons.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
From: David W. Fenton on 29 Jul 2010 18:21
Owen <google(a)healthbase.com.au> wrote in
news:c156bf09-e4c1-48b8-91a6-52e319b90b00(a)z30g2000prg.googlegroups.co
m:

> David - using the lookup value in the recordsource renders the
> form data uneditable.

What if you use the DISTINCTROW predicate?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
From: David W. Fenton on 29 Jul 2010 18:22
John Spencer <JSPENCER(a)Hilltop.umbc> wrote in
news:i2rr3h$rte$1(a)news.eternal-september.org:

> The domain functions (DLookup, DMax, DMin, etc.) are relatively
> slow, but you only notice the "slowness" when you are calling them
> multiple times in a loop of some kind. Or if you are calling them
> in a query and returning a lot of records or are filtering on the
> result of the function call.

As I said in another answer, in A97, they were notably slow on
linked tables, so everybody rolled their own to get the speed back.
A2000 fixed the problem but many of us kept using them out of
intertia and because we'd extend them to offer other features (such
as being able to use a database other than the current one).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
First  |  Prev  | 
Pages: 1 2 3
Prev: opening access2003 from access97
Next: A2010. Can be accessed by phone?