Question regarding query table access

[Zaeed]

Hey, I have a split database that multiple users will be accessing, and am looking at ways to maximise performance.

I was wondering if somebody could tell me how often a query accesses the tables it is linked to.


** The following may be way off base and completely stupid, so if im going in the wrong direction please tell me**

What I am thinking is having a semi global query, or series of query's that hold all the necessary information, so that I can reference a query instead of having to access the linked tables all the time.. The network is not overly fast, as it handles a lot of traffic, thus I'm trying to figure out how to minimise the number of transactions between the front and back ends.

Any help would be appreciated

 

[boblarson]

1. A query does not "hold" data. It displays data from tables.

2. A table, when you view it, is really a query and not the table itself.

3. You may want to read this.