Yeah, I do follow these suggestions.  I think the problem was that so many people were using the full text search that it'd be too slow by the end of the day.

----- Original Message -----
From: Geoff Bowers <[EMAIL PROTECTED]>
Date: Thursday, December 11, 2003 4:08 pm
Subject: Re: How to make ColdFusion Verity/search better?

> [EMAIL PROTECTED] wrote:
> > Although I will reply to Tom's questions soon, what suggestions
> do you
> > have to ensure that I'm not optimizing incorrectly?
>
> I wasn't aiming the "sucks hard" comment at yourself -- it's a
> very
> common response.  So apologies if it seemed that way.
>
> -- optimising
> You can't optimise incorrectly.  You just have to make sure that
> you
> optimise frequently enough to keep the fragmentation of the index
> down.
> -- indexing
> Make sure that the collection fragmentation is minimised by doing
> bulk
> updates rather than lots of little updates.
>
> -- REFERSH vs UPDATE
> REFRESH effectively purges the entire collection and rebuilds from
> scratch.  This might be ok for spring cleaning or smaller
> collections
> but for large collections can make updates very labour intensive.
>
> -- geoff
> http://www.daemon.com.au/
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to