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.
