Derrick, do you mind sharing the script or logic off the list? I installed FusionReactor and here is what I have found so far.
Some pages are taking 8-25 seconds. Found out that there are bad indexes. Here are the stats Average Request Time (ms) 248 Used Memory (KB) (12%) 62,903 Allocated Memory (KB) 73,792 Maximum memory (KB) 504,896 Free memory (KB) 441,992 So looks like memory is not an issue. Then I checked CPU usage as well and CPU also doesnt spike up meaning its the calls to database which is causing issues so far. I will keep you all updated on this and my journey with FusionReactor. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Sun, Jan 24, 2010 at 10:39 PM, Derrick Peavy <derr...@derrickpeavy.com>wrote: > Ajas: > > As always, I caveat my reply with "I am not the usual developer." > > First, I only have one database for client storage for all of the CF apps > on the server. Since, there are only a few on the server, and only 1 is NOT > -MY- app, it's not a problem. > > So, that solves a large part of the problem. At least with Blue Dragon, the > table structure includes a field for the app name. So, I can't see a > reasonable possibility of any problems. > > Second, I expire sessions within 20 or 30 minutes. So, I really don't need > the non identifiable old records laying around for very long. > > In addition to the admin settings of expire in X days, I run a script four > times a day which does a very quick, simple, clean thing - delete records > from the database that are more than 6 hours old. This keeps my database > used for client storage down to 40-100 MB in size depending on the day and > the traffic load. > * > _____________________* > *Derrick Peavy* > derr...@derrickpeavy.com > 404-786-5036 > * > * > *“Innovation distinguishes between a leader and a follower.” -Steve Jobs* > * > * > *"A good deal that used to be a great deal, is not nearly as good as an > awful deal that was once a horrible deal." - Dan Gilbert, > http://bit.ly/8gUruX* > *_____________________* > > > > On Jan 24, 2010, at 10:15 PM, Ajas Mohammed wrote: > > Thanks Charlie and others as well. > > Charlie, your long emails are always helpful. Thanks for sharing. :-) > > I was looking at client storage tables in the 15 databases we have and the > record count is about 388466 in both CDATA and CGLOBAL. And this count is > pretty much same in *Every* 15 of the databases CDATA, CGLOBAL. I am trying > to find why we have so many records. If the flush is set for 1 hr 7 minutes > by default, then I wonder why we have so many records. I believe we have > client variables to expire if not visited in 2 days or so. > > Any thoughts about high number of records in CDATA & CGLOBAL. Can people > share their numbers i.e. record count etc > > Thanks, > > <Ajas Mohammed /> > http://ajashadi.blogspot.com > We cannot become what we need to be, remaining what we are. > No matter what, find a way. Because thats what winners do. > You can't improve what you don't measure. > Quality is never an accident; it is always the result of high intention, > sincere effort, intelligent direction and skillful execution; it represents > the wise choice of many alternatives. > > > On Fri, Jan 15, 2010 at 7:31 PM, Charlie Arehart <char...@carehart.org>wrote: > >> Thanks, and to your next observation, I’ll note that I do list resources >> listing sites using CF in my CF411: >> >> >> http://www.carehart.org/cf411/#cfpowered >> >> >> /charlie >> >> >> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Derrick >> Peavy >> *Sent:* Thursday, January 14, 2010 8:31 PM >> >> *To:* discussion@acfug.org >> *Subject:* Re: [ACFUG Discuss] Ideal memory & Configuration for CF >> Production server? >> >> >> >> I for one appreciate your efforts! >> >> * >> *OT - was asked yesterday during a bus dev call "what is your site built >> in/with" that old saw. When I said cold fusion they chuckled. This from a 26 >> year old. No matter. He asked what other sites are built with CF. That old >> saw. Used to be a list but I am not sure it's kept up anymore. >> >> >> The one that came to mind was Bank of America, but there are other big >> ones. >> >> >> *_____________________* >> >> *Derrick Peavy* >> >> >> ------------------------------------------------------------- >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by FusionLink <http://www.fusionlink.com> >> ------------------------------------------------------------- >> > > >