• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Client/Server Strategies > Optimizing Queries and Forms

Optimizing Queries and Forms

On the whole, the movement to client/server architecture improves performance. If you are not careful when designing your queries, forms, and reports, this movement actually can degrade performance, however. You can do several things to ensure that the movement to client/server applications is beneficial. These techniques are broken down into query techniques and form techniques.

Optimizing Queries

Servers cannot perform many of the functions offered by the Access query builder. The functions that cannot be processed on the server are performed on the workstation. This often results in a large amount of data being sent over the network wire. You can eliminate this extra traffic if you design your queries so that they can be processed solely by the server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint