HP3000-L Archives

October 2008, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Craig Lalley <[log in to unmask]>
Reply To:
Date:
Wed, 8 Oct 2008 14:04:28 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (32 lines)
--- On Wed, 10/8/08, George Kinsler <[log in to unmask]> wrote:


> The Amisys3000  application has its Omnidex configuration
> file in the DICT group for each of the data bases, HEALTH,
> OPTION, ACCTNG.  They're defaulted to not reindex on
> the fly.  If you want it to, remove the "N" and
> reindex.
>  
> It's still good to delete & reindex at least
> weekly.
***********************************************************

I think that is a bit much, my understanding is that Omnidex suggests that a re-index gets done, whenever 20% of the records have been added or deleted to a dataset.  (for performance reasons).

So if you have 1 million accounts and 200,000 got added or deleted last week, then go for it.  

While once a week maybe much, I really like it when I hear...

"When was the last time you re-indexed?"

response:

"How do you do that?"

I know they are going to see some performance improvements. :-)

-Craig

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2