Hello All-
We are experiencing some interesting problems and are running out of ideas
as to the potential solution. Any help would be greatly appreciated. Our
issues are as follows:
After restarting the CF services on the web server, it takes a _very_ long
time to load the first page. Sometimes, the first page loaded becomes
corrupt (broken HTML, style sheets not loaded, JavaScript and so on...). If
we reload the page, the resulting HTML is correct.
The loading of the initial page results in a time out if more than one
request is made at a given time, so the users only see the
"Server busy or unable to fulfill request. The server is unable to fulfill
your request due to extremely high traffic or an unexpected internal error.
Please attempt your request again (if you are repeatedly unsuccessful you
should notify the site administrator). (Location Code: 25)"
error message. This is not ideal, seeing as how if we had to cycle the CF
services at any given time we would need to be the first ones to load the
page. After CF is cycled and the page is hit for the first time, the site
is still slow to load the first time a new user (happens for every user)
hits the site (on the count of 30 or more seconds)� This would result in
many users aborting their page requests since it takes too long to get to
the pages. The delays make the site appear to be down until someone finally
has the patience to wait for a page.
In a different thread a couple of weeks ago, there was an issue regarding
the site model cache. We have delayed the rebuilding of the SLM except for
when the site first comes up or it is explicitly called to refresh from the
WebTop (as a production environment does not change all that much). We did
this to try and decrease the amount of overhead a user may experience when
connecting to the site. We have also implemented page level caching to the
site.
---------------
We have our server tuned to the recommendations made by Allaire in the
Spectra/ColdFusion performance tuning white papers and have upsized all
databases to SQL Server. Here is a copy of my Application.cfm file:
<!--- initialize the application here --->
<cflock timeout="5" throwontimeout="Yes" type="EXCLUSIVE">
<cfa_applicationinitialize name="<MyApp>" setClientCookies="True"
bActiveApp="True" sessionmanagement="True"
sessiontimeout="#CreateTimeSpan(0,0,20,0)#" bactivelog="True" mode="#mode#">
</cflock>
<!--- bUseCache is used for enabling/disabling of the cachecontroller --->
<cflock scope="session" timeout="100" type="Exclusive">
<cfset session.bUseCache = �True�>
</cflock>
<!--- Turn on page level cacheing --->
<cfset request.cfa.siteModel.cachePage = "True">
<!--- set the datasource, We are using to the datasource initialized in the
application --->
<cfset request.<MyApp>.dsn = request.cfa.objectstore.dsn>
--------------
Here is a list of the most time-consuming tags:
79 ms C:\CFUSION\BIN\CFTAGS\CFCACHE.CFM
1664 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\OBJECTSTORE\CFA_OBJECTTYPEGET.
CFM
821 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_HANDLER.CFM
549 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDINSERT.CFM
19578 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDSELECT.CFM
4425 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDUPDATE.CFM
607 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_UPDATEOBJECTDATA.CFM
686 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTC
ACHEWRITE.CFM
631 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTC
REATE.CFM
973 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTG
ET.CFM
496 ms C:\PROGRAM
FILES\ALLAIRE\SPECTRA\HANDLERS\SYSTEM\DEFAULT\UPDATEOBJECTDATA.CFM
-------------------------------------
Our system is as follows:
Win2K SP2, CF 4.5.1 SP2, Spectra 1.5 all hotfixes (upgraded from 1.0 � 1.01
� 1.5), SQL Server 7 for all databases (running on a separate machine), 512
Mb RAM 1x800MHz PIII CPU
Any suggestions are welcome (solutions especially)�
Nelson T. Conard
Ballantyne Consulting Group, Inc.
15720 John J. Delaney Drive
Charlotte, NC 28277
<http://www.ballantyneconsulting.com>
[EMAIL PROTECTED]
Phone (704) 540-0509
Fax (704) 540-7509
BEGIN:VCARD
VERSION:2.1
N:Conard;Nelson
FN:Nelson Conard (E-mail)
ORG:Ballantyne Consulting Group, Inc.
TITLE:IT Consultant
TEL;WORK;VOICE:(704) 540-0509
TEL;HOME;VOICE:(704) 540-0509
TEL;WORK;FAX:(704) 540-7509
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;15720 John J. Delaney Drive=0D=0ASuite 100;Charlotte;NC;28277;United State=
s of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:15720 John J. Delaney Drive=0D=0ASuite 100=0D=0ACharlotte, NC 28277=0D=0AUni=
ted States of America
ADR;HOME:;;1334 Greylyn Drive;Charlotte;NC;28226;United States of America
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:1334 Greylyn Drive=0D=0ACharlotte, NC 28226=0D=0AUnited States of America
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20010104T155814Z
END:VCARD
