A bit of advice on optimization:
1) Sart with exploded debugging on- while the load test is running, use a
browser to hit various pages of the site. Copy the exploded debugging info
from the bottom of the screen. This should give you some detail as to what
is taking so much time (which tags are really slowing you down). You can
then consider techniques to optimize in those areas.
2) You can also set request.cfa.mode.debug = 1 at the bottom of your
application.cfm. This will slow things down even more (it puts Spectra in
debug mode), but you can then use a tag (can anyone refresh my memory on the
tag name) at the bottom of a page to output detailed tag execution stacks.
These stacks enable you to see things like if your handlers are too slow,
etc. . .
HTH!
-c
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/4/00 9:19 AM
Subject: RE: (Extremely) Bad CF/Spectra Performance
Ng,
There are many possible reasons for poor performance in Spectra -- as is
the
case in any programming language.
Doing searching incorrectly can lead to slows, requiring too much
dynamic work
on heavily-hit pages, using loops to invoke a bunch of objects that
should be
passed as one list to cfa_contentobjectinvokemethod can cause slows, not
using
SQL-style queries when they should be used can cause slows, hitting
against
un-optimized Verity collections can cause problems, not having templates
cached
can cause slows, incorrectly setting up Cluster Cats can slow things
down (as I
found out recently), incorrectly configuring the CF engine can cause
problems.
All I can say is that when we have written Spectra apps, the performance
has
been acceptable.
Without a detailed understand of exactly where the problem it, I think
it will
be hard to narrow down the problem.
What may help is to have someone do some kind of application/code review
that
looks in more detail at these issues and/or you might pick a very
specific slow
page or process and ask for comments on that.
Sorry I don't have a magic or simple answer. As stated above, it is
possible to
have poor performing Spectra apps -- but the good news is that it is
ALSO
possible to write well-performing Spectra apps.
David
-----Original Message-----
From: Ng Cheng Kiang [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 3:56 AM
To: [EMAIL PROTECTED]
Subject: (Extremely) Bad CF/Spectra Performance
This is a multi-part message in MIME format.
------=_NextPart_000_000B_01BFFE2C.70A39C90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi!
We've just begun to perform load testing on our CF/Spectra-based website
=
and were extremely disappointed by its performance. We are running the =
test site on a machine with a single 750MHz CPU, 512MB RAM, SCSI2UW =
harddisk, NT 4.0SP5, CF4.51/SP1.01. We have migrated the user database,
=
policy database and contentobject database to SQL 7.0. Whether the SQL =
database is on the same machine or another machine didn't affect our =
test results.
Using SilkPerformer, we noticed that our CPU utilization on the test web
=
server hit 100% when we hit it with as little as 15-20 users, and < 5 =
concurrent connections. Which is extremely bad. Most of CPU time went to
=
cfserver.exe. On peak loads, response time can go above 20s or more.
To give some sort of comparison, we have the same website done in ASP on
=
the same machine, and we can easily load it with 150 users / 500 =
concurrent connections without the CPU utilization hitting 100%, but =
hovering around 70-80%. We were told by our CF/Spectra vendor that CF =
performs much better than ASP, but this is obviously not the case here.
We have tried turning on all the page caching for the site, but it only
=
made a marginal improvement. Apparently we are not the only ones getting
=
poor performance with the product, according to the number of past posts
=
here.=20
Can Allaire or someone who's 'in the know' comment on this and how I can
=
increase the performance? 15-20 concurrent users is big joke compared to
=
what I can get with ASP (10x).
Thanks in advnace.
Regards<br>
CK Ng
------=_NextPart_000_000B_01BFFE2C.70A39C90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>We've just begun to perform load =
testing on our=20
CF/Spectra-based website and were extremely disappointed by its =
performance. We=20
are running the test site on a machine with a single 750MHz CPU, 512MB =
RAM,=20
SCSI2UW harddisk, NT 4.0SP5, CF4.51/SP1.01. We have migrated the user =
database,=20
policy database and contentobject database to SQL 7.0. Whether the SQL =
database=20
is on the same machine or another machine didn't affect our test=20
results.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Using SilkPerformer, we noticed that =
our CPU=20
utilization on the test web server hit 100% when we hit it with as =
little as=20
15-20 users, and < 5 concurrent connections. Which is extremely bad.
=
Most of=20
CPU time went to cfserver.exe. On peak loads, response time can go above
=
20s or=20
more.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>To give some sort of comparison, we =
have the same=20
website done in ASP on the same machine, and we can easily load it with
=
150=20
users / 500 concurrent connections without the CPU utilization hitting =
100%, but=20
hovering around 70-80%. We were told by our CF/Spectra vendor that CF =
performs=20
much better than ASP, but this is obviously not the case =
here.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>We have tried turning on all the page =
caching for=20
the site, but it only made a marginal improvement. Apparently we are not
=
the=20
only ones getting poor performance with the product, according to the =
number of=20
past posts here. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Can Allaire or someone who's 'in the =
know' comment=20
on this and how I can increase the performance? 15-20 concurrent users =
is big=20
joke compared to what I can get with ASP (10x).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advnace.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards<br><BR>CK=20
Ng<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_000B_01BFFE2C.70A39C90--
------------------------------------------------------------------------
------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_
talk or
send a message to [EMAIL PROTECTED] with
'unsubscribe' in
the body.
------------------------------------------------------------------------
------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_
talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
