Jim,
Can you get them to take a look at the following things for me:
1. Check the application log.
------------------------------
This file is located in <coldfusion install root>/log/ (by default,
it would be something like C:\CFUSION\LOG). It is good to browse this file
from time to time to see application errors/warnings. However, I have seen
server performance issues when this file grew too large (by large, I mean
many megabytes). It's a good idea to back up the log by renaming the file to
something like application_yyyy_mm_dd.log etc... the server will create its
own new application.log file as needed.
In 1.0, there was also an issue with a setting for the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\CustomTags
...where by the string, CFMLTagSearchPath, had an incorrect path set
to "C:\Program Files\allaire\spectra\" which should have been "C:\Program
Files\allaire\spectra\customtags".
There may also be an issue if you use mods and the order is not
correct. I set my path to: "C:\Program
Files\allaire\spectra\mods\customtags,C:\Program
Files\allaire\spectra\customtags,C:\CFUSION\CustomTags", so that mods should
be found before the original tags. BTW, we've ensured that this is correct
for 1.5.1.
Incorrect customtag search path settings may lead to "occlusion
warnings", that can fill up the application log (quickly).
2. Quantity is rarely the issue with object updates.
----------------------------------------------------
Can you tell me more about the article type design? Does it use
metadata?
It is more than likely that the verity collections are not being
optimized. One way to quickly measure the level of "optimization" is to look
at the collection directories themselves...
For example, your article property collections are probably stored
as subdirectories of
<spectra install root>\collections\
(typically C:\Program Files\Allaire\spectra\collections\), with the
subdirectory name using the convention 'propertyUUID_propertyname'. And the
standard metadata collections are in 'cfa_metadata_categories' and
'cfa_metadata_keywords'. In each of these directories, look at the files in
directory 'custom\parts\'. In here you should see files like 00000001.ddd
and 00000001.did. If there are only two files (i.e. a 'ddd' and a 'did'
file) it is likely that the collections are optimized. Each time you add
something to the collection, a separate file is created... and when you
optimize, they're all collated back into one set of files. I suspect that
one or more of the article type's collections' parts directories are full of
these extra collections files, and thus un-optimized.
See: http://allaire.com/handlers/index.cfm?ID=20224&Method=Full for
more info.
3. Content Object Find
----------------------
Are you using the tag cfa_contentObjectFind in 1.0? If so, can you
take some metrics on its performance? In 1.0, it had the potential to be a
bottleneck for certain object-type designs. In 1.5.1, this tag has been
significantly re-architected to cater for a broader range of type designs.
If none of this helps, let me know!
Pete
-----Original Message-----
From: Jim Biancolo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 9:59 AM
To: Spectra-Talk
Subject: Instability, Performance Degradation
Hi folks,
Our one-and-only deployed app has fallen on hard times. I would fiddle
with this before posting, but the client has taken over maintenance of the
app, so I can't really experiment, I can merely advise. There are two
problems:
[1] It takes around 30 seconds to save an "article" object. I'm
estimating there are several hundred articles, and probably another several
hundred objects total. So I'm guessing quantity isn't the issue.
[2] After about 3 to 5 days, the app slows waaaay down and the server
needs to be rebooted.
For [1], I'm thinking the first place to look is the Verity
collections. Are there other likely culprits?
An additional question for [1] . . . I read that you should not
repair/optimize a collection while a search or index is being run. Is
there a way to prevent this short of bringing down the app? Can Verity
collections be locked and then repaired/optimized via a script?
For [2], I'm at a loss. The platform is Spectra 1.01, CF 4.5 sp 2,
Win2K. There is one web server and one DB server. I know a problem like
this is impossible to diagnose definitively without testing, but I was
wondering what kind of continuous uptime others are getting on similar
platforms? I'm used to NT boxes needing regular reboots, but I'm not as
familiar with Win2K. Same deal?
Thanks!
Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
