Just to add to this thought... a full rebuild could also be done
incrementaly. Rather than asking for the whole site to be done in
one hit
just ask for a 100 objects at a go.
There is *no* valid reason for a regular *complete* rebuild. It is
however
important to have a mechanism that can achieve an index build from
scratch
in the event that you lose the index entirely.
-- Geoff
> -----Original Message-----
> From: Aaron Shurmer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 4:54 PM
> To: Spectra-Talk
> Subject: RE: Large object sets, lots of data, Verity and memory
>
>
> Hmmm, will the client not accept an index optimization to be done
> instead of
> a full rebuild? A full rebuild is always going to be an insanely
long
> running process when there are that many objects involved, which
makes
> things difficult if it's a live production box. All i can say is, if
> it's a
> full rebuild that they want, it should prolly be done on another box
> that is
> not live, and when it is finished, copy it across to the live box...
>
> Internally, we update incrementally every hour, and optimize every
> night, it
> works a treat, we have had a high volume production box doing this
> for weeks
> without a hitch.
>
> Cheers,
> Aaron
>
> -----Original Message-----
> From: Stephen Collins [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 19 July 2001 4:43 PM
> To: Spectra-Talk
> Subject: RE: Large object sets, lots of data, Verity and memory
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Aaron
>
> We ALREADY do incremental updates automatically as well. A script
> goes and looks each hour for updated objects within the last hour
and
> does what you've suggested. It works a treat as it only updates a
> few objects at a time.
>
> The script causing me problems is a weekly full rebuild of the
> indexes the client has requested on the basis of their worry that
> incremental index updates will ultimately make the index work at a
> less than optimal level. I don't really know whether this is valid
> or not, but it's a deliverable.
>
> Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
