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={ap plication. home}/../l ib/updates ,{applicat ion.home}/ ../lib,{ap plication. home}/../g ateway/lib /,{applica tion.home} /../wwwroo t/WEB-INF/ cfform/jar s
JVM arguments -server -Dsun.io.useCanonCaches=fa lse -XX:MaxPermSize=128m -Dcoldfusion.rootDir={appl ication.ho me}/../ -Dcoldfusion.libPath={appl ication.ho me}/../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
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={ap
JVM arguments -server -Dsun.io.useCanonCaches=fa
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also do NOT break into smaller queries - the overhead is in connecting to the database server - NOT in the number of records being processed.