In .adp project, Where is query executed ?

  • Thread starter Thread starter suntisuk
  • Start date Start date
Dear Suntisuk:

The default in an ADP is to pass the query string to the server. The
server performs all the processing and returns the results.

There are some advantages to doing this compared with Jet and MDBs.
The access to the data is performed on the server, and does not
involve sending index information across the network. In situations
with low bandwidth, or especially where there is considerable network
latency, this makes a huge difference in performance.

Also, it is possible to put the power in the server and have the
client computers share this benefit. It is commonly less expensive to
set up a single powerful server and get excellent performance. With a
typical MDB/Jet setup, each client computer may require upgrades to
achieve the same results, and these upgrades may include improving the
network as well as the computers.

Is it executed locally on client or on SQL server ?

TIA
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
It most cases, be it a adp project, or even a standard mdb file with dao via
odbc to sql server, the query executed on the server side.

However, adp projects certainly ensure that all queries execute on the
server side. if you use JET/dao via odbc, then some extra cautions need to
be taken to ensure that things work well on the server side.
 
Back
Top