One more option, you can use CFA_ExecutionTime to identify slow parts of
your code. I find it very usefull when I have something like so:
Do X
Do Y
Do Z
I can use the tag to see whether X or Y or Z is slow (and bare in mind that
these items can be 1-100 lines of code). This is also an awesome tag to use
outside of Spectra. Don't forget that many of the cool Spectra tags can be
used outside of Spectra apps, especially CFA_Dump. (I don't know how I
survived before this tag.)
I believe the tag Charles is talking about is CFA_TagDebugOutput.
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Charles Teague [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 04, 2000 11:58 AM
> To: '[EMAIL PROTECTED] '
> Subject: RE: (Extremely) Bad CF/Spectra Performance
>
>
> 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.
------------------------------------------------------------------------------
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.
