Hi David,
Thanks for your comments. Right now, I have not used any Verity searches
(nor any other searches) yet.
I've went through all the procedures stated in Allaire's performance tuning
articles in their knowledgebase
as far as CF tuning is concerned. As mentioned in another post, the only
page in the pages load tested that
actually have any Spectra stuff is my main page, which has only 3 containers
with the default "Schedule Content"
rule. I have other Spectra pages but I have not load tested them yet.
Caching pages reduced response time
(as expected) but CPU utilisation remains high. :(
Regards
Ng CK
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 04, 2000 9:19 PM
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.
