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
-------------------------------------------------------------