If you have isolated the periodic slowdown problem to your queries and
MySQL database, and optimising the queries has helped, then I suggest
that you look at the following :
a) upgrade your MySQL to the latest production release (5.0.xx).
b) Use latest MYSQl Admin to tune up the caching on your s
ssie
Subject: [cfaussie] Re: frustrated CF newbie
For what it's worth, I seem to have resolved this issue by optimising
some of the sql queries.
I still can't claim to understand exactly what the problem was, but by
using *a lot* of cfdump statments, I found that a particular query
occasi
For what it's worth, I seem to have resolved this issue by optimising
some of the sql queries.
I still can't claim to understand exactly what the problem was, but by
using *a lot* of cfdump statments, I found that a particular query
occasionaly ran *way* slow (we are using MySQL 4.1). Adding an
I get the slowdown thing going on in a different environment.
Things just seem to freeze. Can carry on typing and eventually the
machine catches up and displays what I type.
My development machine is a Windows XP laptop and it runs SQL Server,
CF 8 and of course the IE web browser. Loads of RAM
On 15/04/2008, at 12:03 PM, nedlud wrote:
> Can anyone offer some clarification on this?
Ah, trusted cache, good friend of ColdFusion consultants everywhere.
This is how it works: In development with trusted cache off you edit-
save-test-edit-save-test, so each time a new source file is
enco
I have several FB 3 apps running on some rather old P3 CF5 / Linux machines.
They see moderate traffic and some heavy peak activity.
When they were first set up, they saw very little traffic and never had any
issues.
After several months the traffic picked up on a couple of the sites ,and we
saw
On Apr 15, 12:03 pm, nedlud <[EMAIL PROTECTED]> wrote:
> Reading the Macromedia book on CFmx, the chapter on performance says
> that enabling "Trusted Cache" on production can make it faster. The
> sys admin is saying that this cahce only stores compiled class files.
> I had assumed the cahce was
e the ones where it is generating the class file again?
Steve
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of nedlud
Sent: Tuesday, 15 April 2008 12:04 PM
To: cfaussie
Subject: [cfaussie] Re: frustrated CF newbie
I was just talking to the sysadmin
I was just talking to the sysadmin again, but that's left me more
confused than I was before.
Reading the Macromedia book on CFmx, the chapter on performance says
that enabling "Trusted Cache" on production can make it faster. The
sys admin is saying that this cahce only stores compiled class fil
Thanks everyone.
I *think* we are using CF6. I know the sys admin is experimenting with
CF8 with a view to rolling it out sometime soon, but it's not
available to me currently.
OS is RH ("Red Hat Enterprise Linux ES release 4 (Nahant Update 6)"
says the server). Single CPU on the dev machine, an
harlie
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of CyberAngel
Sent: Monday, April 14, 2008 5:48 PM
To: 'CyberAngel'; cfaussie@googlegroups.com
Subject: [cfaussie] Re: frustrated CF newbie
Let me take that back, I forgot I am in developer mod
Let me take that back, I forgot I am in developer mode :-)
-Original Message-
From: CyberAngel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 15 April 2008 7:46 AM
To: 'cfaussie@googlegroups.com'
Subject: RE: [cfaussie] Re: frustrated CF newbie
Charlie.
I was under the impressio
: frustrated CF newbie
Lucien, what version of CF are you running? Assuming it's CF7 or above, take
a look at the Client Variables page in the CF Admin. There's a setting at
the bottom for purge interval. The default is 1 hour 7 minutes, and if your
problem of problems "every now and
Lucien, what version of CF are you running? Assuming it's CF7 or above, take
a look at the Client Variables page in the CF Admin. There's a setting at
the bottom for purge interval. The default is 1 hour 7 minutes, and if your
problem of problems "every now and again" matched that interval, I'd pr
oh usenet I remember that... fond memories.. :)
--
Gary Barber
Freelance User Interaction Designer/ Information Architect
Web: radharc.com.au
blog: manwithnoblog.com
Kay Smoljak wrote:
> On Mon, Apr 14, 2008 at 4:57 PM, Mark Mandel <[EMAIL PROTECTED]> wrote:
>
>> That's the first ema
On Mon, Apr 14, 2008 at 4:57 PM, Mark Mandel <[EMAIL PROTECTED]> wrote:
> That's the first email I've ever seen with footnotes...
You've obviously never hung out on Usenet. Geoff is old-school :)
--
Kay Smoljak
business: www.cleverstarfish.com
coldfusion: kay.smoljak.com
personal: goatlady.wor
That's the first email I've ever seen with footnotes...
Mark
On Mon, Apr 14, 2008 at 6:45 PM, Geoff Bowers <[EMAIL PROTECTED]> wrote:
>
> On Apr 14, 5:11 pm, nedlud <[EMAIL PROTECTED]> wrote:
> > The only common factor I can find is that it seems to happen about
> > every 100 - 110 seconds (a
On Apr 14, 5:11 pm, nedlud <[EMAIL PROTECTED]> wrote:
> The only common factor I can find is that it seems to happen about
> every 100 - 110 seconds (a little less than every 2 minutes). The
> session variables are set to time out in 20 minutes, so I don't think
> they are causing the problem.
Wh
you may already know this but just in case:
I'm thinking it might be worthwhile turning on the debugging on the
server to specifically looking for
"Database Activity"
"Select this check box to show the database activity for the SQL Query
events and Stored Procedure events in the debugging output
It's been a long time since I've dabbed with fusebox 3, but see if it has a
production/development setting in the configurations like the fusebox 4+ etc
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group
20 matches
Mail list logo