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

Chapter 21. Client/Server Strategies > Reducing the Number of Connections

Reducing the Number of Connections

Some database servers are capable of running multiple queries on one connection. Other servers, such as Microsoft SQL Server, are capable of processing only one query per connection. You should try to limit the number of connections required by your application. This section looks at some ways you can reduce the number of connections your application requires.

Dynasets containing more than 100 records require two connections—one to fetch the key values from the server and the other to fetch the data associated with the first 100 records. Therefore, try to limit query results to fewer than 100 records wherever possible.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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