Link to home
Start Free TrialLog in
Avatar of mnmorency
mnmorency

asked on

Tips for tuning Cold Fusion

I am running ColdFusion MX  Version  7,0,1,116466 Standard Edition on a Windows 2003 server.  We primarily use it as a reporting and charting tool that queries a SQL 2000 server also running Windows 2003.  The CF queries are pretty large, can anyone suggest tweaks to the default configuration to fully maximize the server's hardware potential.  Below is our current config.

Thanks
Mark

General Settings  
Simultaneous request limit  50    
Timeout requests  No    
Request Time Limit  90 seconds  
Use UUID for CFToken  No    
Enable Whitespace Management  Yes    
Missing Template Handler    
Site-wide Error Handler    
Enable HTTP status codes  Yes    
Enable Global Script Protection  Yes    
Default CFForm ScriptSrc Directory  /CFIDE/scripts/    
Maximum size of post data  500 MB  
Maximum number of report threads  10    
Request Throttle Threshold  2 MB  
Request Throttle Memory  200 MB  
Caching  
Template cache size  1024 templates  
Enable trusted cache  No    
Cached query limit  100  
Save Class Files  Yes    
Cache web server paths  No  
Client Variable Settings  
Default client variable store  Cookie    
Purge Interval  1 hours 7 minutes    
Client Stores  
Cookie    
Type  COOKIE    
Description  Client based text file.    
Purge data after time limit  Yes    
Time limit  10 days  
Disable global updates  No    
Registry    
Type  REGISTRY    
Description  System registry.    
Purge data after time limit  Yes    
Time limit  90 days  
Disable global updates  No    
Memory Variables  
J2EE Sessions  No    
Application Variables  
Enable Application Variables  Yes    
Default Timeout  0,2,0,0    
Maximum Timeout  0,4,0,0    
Session Variables
Enable session variables  Yes    
Default Timeout  0,2,0,0    
Maximum Timeout  0,2,0,0    
ColdFusion Mappings  
/CFIDE    C:\Inetpub\wwwroot\CFIDE    
/gateway    C:\CFusionMX7\gateway\cfc    
Mail Connection Settings  
Default Server Port  2525    
Connection Timeout  60 seconds  
Spool Interval  15 seconds  
Mail Delivery Threads  10    
Maintain Connection to Mail Server  No    
Messages Spooled to Memory  50000    
Default CFMail Charset  UTF-8    

Java and JVM  
Java virtual machine path  C:/CFusionMX7/runtime/jre    
Initial memory size  MB  
Maximum memory size  512 MB  
Class path  -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars    
JVM arguments  -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib    

Debugging Settings  
Enable debugging  No    
Enable Robust Exception Information  Yes    
Display format  classic.cfm    
Execution times  Yes    
Execution time format  summary    
Execution time highlight threshold  250 ms  
Database activity  Yes    
Exception information  Yes    
Tracing information  Yes    
Timer Information  No    
Variables  Yes    
Variables  
Application  No    
CGI  Yes    
Client  Yes    
Cookie  Yes    
Form  Yes    
Request  No    
Server  No    
Session  Yes    
URL  Yes    
Debugging IP Addresses  
Debugging IP Address Restrictions    
Logging Settings  
Log directory  C:\CFusionMX7\logs    
Maximum file size  5000 kb  
Maximum number of archives  10    
Log slow pages  No    
Slow page time limit  30 seconds  
Log CORBA calls  No    
Log scheduled tasks  No    
ASKER CERTIFIED SOLUTION
Avatar of mrichmon
mrichmon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mrichmon
mrichmon

If it is on the same machine then it is worse security.  Don't do that if you can help it.

Also do NOT break into smaller queries - the overhead is in connecting to the database server - NOT in the number of records being processed.
Avatar of mnmorency

ASKER

Both machines are on a GB switch and Windows network monitoring (task manager) shows low utilization.  All CF pages and queries seem slow, any other suggestions for improvement?
Youneed to rung some tests to determine what is causing the slowness.  For example you can turn on debug output on the cf page and see which portion of the page is taking the time up.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial