Dave,
I'd have to second Jon's point... in my experience there is no reasonable
way to make Spectra perform well. Our successful deployments of Spectra have
all been for sites with just a few hundred users per day and a very limited
role for Spectra-unique functionality. Consider replacing large chunks of
your
Spectra code with "pure CF". It's the only way to scale the thing. And,
since
MacroAllaire is ending Spectra support in 2 years, it'll give you a head
start
on moving on to a better architecture.
Chris Tweney
Media Application Developer
roundpeg
www.roundpeg.com
1700 California Suite 260
San Francisco, CA. 94109
Ph. 415-437-3900 x 140
Fax 415-437-3904
> -----Original Message-----
> From: Jon Cole [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 2:24 PM
> To: Spectra-Talk
> Subject: RE: Performance
>
>
> SQL Server takes something like 85 - 90% of all available
> resources as soon
> as it starts. In my experience moving SQL to a different
> machine has the
> biggest effect on server performance. Spectra is also killing
> the machine .
> .. . oops did I say that.
>
> Thank You,
> Jon Cole ACP
> DevTech Inc.
> [EMAIL PROTECTED]
> 206.956.0888
> Learn more about DevTech @ www.Dev-Tech.com
>
>
> "I hate to advocate drugs, alcohol, violence, or insanity to
> anyone, but
> they've always worked for me."
>
> - Dr. Hunter S. Thompson
>
>
> -----Original Message-----
> From: Dave [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 1:53 PM
> To: Spectra-Talk
> Subject: Performance
>
>
> I am running a reasonably active site with CF4.5,
> Spectra 1.0.1 and SQL
> Server 7 on a PIII 800 with 512M RAM. Amongst other ills,
> from time to time
> response times plummet, or CPU usage goes to 100% (or both).
>
> I am considering adding RAM, moving SQL to its own box,
> upgrading to
> Spectra 1.5. Does anyone have any feel (or even hard numbers)
> for which
> approach is most critical, or gives me the biggest bang for
> the buck.
>
> Do I need to implement any or all of these, or is there a
> better solutions
> which I haven't considered?
>
> Thanks for any input
> Dave
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
