Peter,

On Nov 13, 2006, at 12:09 PM, PETER SHEATS wrote:

> Well I got the new site up for awhile (we're using CommonSpot from
> Paperthin) and it was ok for awhile but then started slowing down  
> after
> awhile.  So I took it back down.

  -  Just a thought:  Check your server logs for a Spam Bot  
submitting bogus data (or even binary data) to the search form on the  
index page.  On a couple of sites I work on this is increasingly  
becoming a problem.  If this is the case, you can fix it in the short  
term by adding some additional filters for the search data (or  
whatever form data might be the problem), strict typing in your CFC  
arguments, and <cfqueryparams> in your search queries.   It won't  
eliminate the problem, but it will abort the bad requests faster so  
your server can get back to business.

-  Another thought:   Is your navigation query cached?  If not, it  
could be a bottleneck since it's being executed on every page request.

> I'm going to put the new site back up in a few minutes and see how it
> goes again.  Jon, if I had Report Execution Times on but had Enable
> Debugging off, would it have played a role - because I did have  
> that on
> but I had enable debugging off.

-  That shouldn't have played a role once debugging was off - I don't  
think.   Sounds more likely that there are long running requests on  
your pages (executing closely together)  that keep filling up the  
system resources until it slows down.

> The settings that CommonSpot recommend are below but I went ahead and
> checked the Timeout requests and set it to 60 for now.

- I might suggest calling PaperThin for support on the matter.  You  
paid a good chunk of change for the CMS - I assume.   I don't know  
much about CommonSpot since I use FarCry, ModelGlue, or my own   
framework much of the time, but some of their recommended settings  
don't make sense in a production environment.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260220
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to