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

Chapter 18. Working with Data from Exter... > Using Automation to Meet Performance...

Using Automation to Meet Performance Demands

Suppose your boss comes to you, complaining that your Access database is growing too large (some of the tables contain more than 30,000 records). Your company is considering purchasing SQL Server, but it will not happen for at least a year. The users are starting to complain that compacting takes too long, even on their fast machines. To make matters worse, they are beginning to notice degradation in query performance.

You have already implemented the performance tips presented in this book. Although these techniques improved performance, they are insufficient in light of the fact that the database is growing so rapidly. The users explained that, although many of the tables were old, they could possibly be needed from time to time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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