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.
