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

Chapter 24. MOVING WORKGROUP APPLICATION... > KEEPING CERTAIN ISSUES IN MIND WITH ...

KEEPING CERTAIN ISSUES IN MIND WITH ACCESS AND SQL SERVER

You should now have a better understanding about not only what client/server applications are, but also how to implement them successfully. The most important points to take away from this chapter are the following:

  • Plan your file-server applications with client/server migration in mind. It's easier to do it right the first time than be forced to rework your application later on.

  • Limit your data. Always be conscious of how much data you're passing across your network. Move only as much data as is truly needed.

  • Take advantage of server processes. Make sure that your queries are actually processing on the server. You can use some tracing mechanism to verify this, as mentioned in the section “Query Processing on the Server.” Also consider the advantages of using SQL Pass-Through queries and stored procedures.

  • Know what upsizing is all about. Understand that upsizing means moving your data to a back-end server that specializes in query processing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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