MS Access Multiuser - More efficient; querying queries or querying tables?

Author

More efficient; querying queries or querying tables?

rgrantz

2005-04-06, 8:06 pm

Sorry I split this up into 2 posts, I forgot to add this to my previous
"efficiency" post.

Is there a general rule of the thumb regarding querying in terms of whether
to use other queries or a table for the data? I have a query that DOES
return more of the records than I need, and I can query THAT as a
recordsource for another form (adding additional criteria), or I can make a
new query to get just the fields I need from the tables.

This is a split db for multiple users, front end on all pc's and one backend
on shared drive on network.

Any advice is appreciated, and thanks

Rick Brandt

2005-04-06, 8:06 pm

rgrantz wrote:
> Sorry I split this up into 2 posts, I forgot to add this to my
> previous "efficiency" post.
>
> Is there a general rule of the thumb regarding querying in terms of
> whether to use other queries or a table for the data? I have a query
> that DOES return more of the records than I need, and I can query
> THAT as a recordsource for another form (adding additional criteria),
> or I can make a new query to get just the fields I need from the
> tables.
>
> This is a split db for multiple users, front end on all pc's and one
> backend on shared drive on network.
>
> Any advice is appreciated, and thanks

It depends. I have had "all in one" queries that were made much faster by
replacing tables with other queries that "pre-processed" some of the
selecting that was going on and I have tried the same on other queries where
it made no difference. Query optimization is such a complex area that I
doubt there is any "rule" that generally applies.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Sponsored Links