What data is Transferred Over the Wire

[Guest]

Can someone clarify an issue for me? I have an Access 97 application split
into a FE and BE. The FE is on each user's pc and the BE on is a Novell
server. Say I have a query SELECT * FROM Orders WHERE OrderID = 15. Is the
entire Orders table transferred over the network and then filtered at the
client side. Or is only order #15 transferred over the network? Thank you
very much for your help.

 

[Arvin Meyer [MVP]]

Assuming OrderID is indexed, the OrderID column is transmitted over the wire
to the workstation. The value of 15 is read, then the page that it's on is
retrieved from the server. Processing takes place on the workstation, but
using JET, the entire table is not transmitted if the indexes are used
properly. With a server based engine, all processing takes place on the
server and then the record (and possibly the page) is transmitted. Assuming
well designed databases, servers are faster when:

1. Datasets are large
2. Numbers of users are large
3. Network traffic is heavy.

Servers are slower when
1. Transaction logging is turned on and there are lots of requests.
2. The server is engaged in other activity.
3. Network traffic is light and datasets are small.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access