Chapter 10 Achieving Optimum Performance with PowerDynamo

Converting an inefficient Web site to an efficient Web site

Let's say that the high-volume Web site "Hockey" has an average of one request every two seconds, 24 hours a day. Half the data being accessed changes at most once a day (statistics, player info, and so on), while the other half is constantly changing (game scores, penalties, and so on).

We should look at each area of the site to determine how to eliminate inefficient or unnecessary processing.

We'll look at four key areas to ensure that the Web site is operating as efficiently as possible:

The Web documents
The document cache
The use of scheduling
The connections

If you use Windows NT, you can use the Performance Monitor to monitor your Web site's performance. For more information see "Using the Performance Monitor".

Working with documents

Any document that takes longer than two seconds to execute can slow down a system. Wherever possible, documents must be as specific as possible so queries can execute as quickly and take no longer than the time between requests to complete. Ideally, each request should receive 100% CPU time. If this goal is attained, requests are processed at maximum efficiency.

Performance degradation is also caused by putting multiple queries in one script. It is far more efficient to have many specific documents than to have fewer general documents. More specific documents allow you to take advantage of output caching.

Categorize your documents

By categorizing your documents and setting them up accordingly, you can eliminate much processing time. Categorizing automatically uses caching and scheduling to enhance performance. You can categorize each document into one of the following three categories:

Data that changes less than once an hour or documents that take a long time to execute - schedule these documents to run on a regular basis. This makes the output readily available for subsequent requests.
Data that changes once an hour or more often - assign appropriate cachedOutputTimeOut values to these documents. See "Setting a cachedOutputTimeOut value" for more information.
Data that is constantly changing and must be accurate to the minute, and documents that take parameters - do not set cachedOutputTimeOut values for these documents or schedule them with the scheduling wizard. Ensure that the cache size is set high enough to hold their source so those requests can be processed as quickly as possible.

Set a cache size that is appropriate for the Web site that will be utilizing it. It is important that the size of the cache is large enough to hold all the active documents for at least a brief duration of time. If a cache size is too small, the stored document output and source may be flushed to make room for more current documents before they have a chance to be re-used before being unloaded.

Working with connections

There are several ways to control the way connections work within a Web site:

Setting a connection timeout
Setting maximum and minimum number of connections
Creating permanent or temporary connections.

Connection timeout value

The first value you should set to increase performance is the connection timeout value. The default connection timeout value of 0 indicates that all connections remain in the connection pool. Because of the fluctuating traffic that the Hockey Web site receives, this is not what we are looking for. For the best performance, we will set the connection timeout value to 15, which holds a connection in the pool for 15 minutes after the last time it was active . The number of connections stored in the connection pool fluctuates with the Web site volume. This produces better performance than constantly creating new connections or keeping enough connections in the pool to always cover the peak times of volume.

User connections

At peak times, the Hockey Web site uses a maximum of 20 user connections. This does not slow down the overall performance of the Web site, so we can set the maximum number of user connections to 20.

Number of user connections
Caching document output and scheduling documents can greatly reduce the required number of user connections for your Web site.

During the slow times, there is a minimum of four user connections per definition being used at any one time. By setting the minimum number of User connections to four, we ensure that four connections will always remain in each connection pool ready for use.

Dynamo connections

The minimum and maximum connections for user connections applies per definition . The minimum and maximum number of connections for Dynamo connections is a total, since each Web site has only one Dynamo connection. For example, if there are two user connections defined in the connections folder of Sybase Central; ("sales_db" and "marketing_db"), setting a minimum number of user connections to four means that eight connections would be held in the connection pool, once created.

Our Hockey Web site requires a slightly smaller number of Dynamo connections than user connections. We'll set the maximum number of Dynamo connections to fifteen and the minimum number of Dynamo connections to five.

Use of permanent and temporary connections

Finally, let's look at whether the Hockey Web site is using temporary or permanent connections within its scripts. We need to ensure that temporary user connections are used only in the appropriate instances. Scripts that use temporary user connections that are reused in day-to-day Web use should be changed to permanent user connections to minimize the processing required to create a new connection each time.

For more information on connections, see "Working with connections".