LISTSERV - HP3000-L Archives

HP3000-L Archives

November 2003, Week 2

HP3000-L@RAVEN.UTC.EDU

	LISTSERV Archives
	HP3000-L Home
	HP3000-L November 2003, Week 2

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

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 >>]

Subject:	Re: image database omnidex error msg
From:	Craig Lalley <[log in to unmask]>
Reply To:	Craig Lalley <[log in to unmask]>
Date:	Mon, 10 Nov 2003 08:20:38 -0800
Content-Type:	text/plain
Parts/Attachments:	text/plain (26 lines)

--- "Leonard S. Berkowitz" <[log in to unmask]> wrote:
> "The nice thing about OMNIDEX is you can just re-execute your install job,
> which will tidy things up a bit, then reindex."
>
> Yes, if you have a small number of records. We have one dataset, the indexing
> of which, took seven hours on a 997-1200.

Ah, but there is a trick that can be done, it won't help you shorten the "seven
hours" but...

Re-indexing is by default a serial threaded process.  It does not have to be.
If you have enough memory and disc resources, each processor can re-index one
data set.  Use DBINSTAL instead of DBUTIL, open the database in READONLY and
viola.

-Craig

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

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

ATOM RSS1 RSS2

RAVEN.UTC.EDU