MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information download pdf (Page 107)

102

CONFIGURING AND ADMINISTERING COLDFUSION 9

Using the ColdFusion Server Monitor

Last updated 2/21/2012

Variable memory usage

Configure client variable storage to use cookies or an RDBMS for best performance when using client variables; you

do this on the Client Variables page of the ColdFusion Administrator.

Wherever possible, it is best to fully scope your variable names, especially when using the isdefined() function. For

example,

<cfif isdefined("variables.myvariable")> performs much better than <cfif

isdefined("myvariable")>.

To monitor how variables use memory, view the reports in the “Memory Usage” on page 96 of the Server Monitor.

Request handling

The Simultaneous Requests setting on the Settings page of the ColdFusion Administrator has the largest effect on how

well an application performs under load. This setting dictates how many threads are used to simultaneously process

incoming requests. For most applications, a good starting point for the optimal value for this setting is three per

processor; you can set a dual processor computer to six simultaneous requests. To find the optimal value for this

setting, test your application under load with different values until you find the value that provides the best

performance under load. While you test your application, you can view the average response time on the Server

Monitor Summary page and the reports in

“Statistics” on page 94.

Caching

You can turn on the trusted-cache setting on the Caching page of the ColdFusion Administrator for production

applications so that the server does not check the file system to see if the CFML source code changed since it was last

compiled. This setting provides the benefit of minimizing system I/O, which has a major effect on performance. Set

the template-cache size on the Caching page of the ColdFusion Administrator to be roughly equal to the number of

ColdFusion templates that are normally used. To monitor how your settings affect performance, use the

“Template

Cache Status” on page 95 in the Request Statistics section of the Server Monitor.

In addition, use one of the following methods to cache wherever possible in your application:

• The cfcache tag

• Database query caching. Database caching can provide significant performance and scalability improvements, and

is accomplished with the

cachedwithin and cachedafter attributes of database tags that support them, such as

the

cfquery tag.

• Storing data in persistent scopes such as session, making it available for longer than a single request.

Database response time

Wherever possible, it's best to allow database servers to handle data manipulation. Adding SQL code to handle this

work is much more efficient than doing string manipulations or doing in-memory queries (query of queries).

Additionally, stored procedures generally provide a higher level of performance than regular SQL queries. Converting

queries in

cfquery calls to stored procedures and using the cfstoredproc tag typically improves performance. To

view database response time information, use the Database section of the Server Monitor (see

“Database” on page 97).

1 2 ... 102 103 104 105 106 107 108 109 110 111 112 ... 173 174

MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information Page 107

Comments to this Manuals

MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information Page 107

Comments to this Manuals

Related products and manuals for Servers MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER