Optimization

S

Stephen Haley

Is there any difference in performance both in a pure access environment and
in using adp/sql server between
a) Linked Mainform/subforms
b) Unbound subforms using an event trigger to requery the database for
the single record needed for the subform?

Really what I am trying to understand is what is retrieved for the linked
subform when you Initially open the form and when you change the record in
the master form in that If access retrieves more than the single record
required it may have an impact on performance.

Secondly does Access have any inteligent caching in that on several forms I
have more than one drop boxes bound to the same query - will access issue
the query more than once or use the dataset retrieved from the first cbo. Is
there any diff with an adp front end.

Lastly is there anyway to see what queries are hitting the server via a log
just to make sure that there is nothing strange going on.


Hope this makes sense
Stephen
 
S

Sylvain Lafontaine

Use the SQL-Server Profiler and you will find the answer to all of your
questions (well, not exactly *all* of your questions but yes for many of
them).

S. L.
 
S

Stephen Haley

Hmm
Most surprised - Access actually optimizes the SQL and issues a where
Linkfield=Linkvalue with the query
No need to do anything

rgds
Stephen
 
T

Tony Toews

Stephen Haley said:
Most surprised - Access actually optimizes the SQL and issues a where
Linkfield=Linkvalue with the query
No need to do anything
Click to expand...

Thanks for posting back.

I've been quite surprised myself with how good Access does in
optimizing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top