Updating of INVERTED METAMORPH indexes

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Updating of INVERTED METAMORPH indexes

Post by barry.marcus »

I seem to recall reading a while back in the documentation that metamorph inverted indexes do not automatically update as data in the underlying table is changed, but now I can't find that documentation page. Is this true? If it is true, is this a default behavior that can be overridden. That is, is there any way to create a MMI index that *does* automatically update?

Thanks.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Updating of INVERTED METAMORPH indexes

Post by John »

The index is always updated, but not optimized as the data changes. You can configure chkind to control how often the index is optimized, or manually choose when to optimize by reissuing the create index statement.
John Turnbull
Thunderstone Software
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Updating of INVERTED METAMORPH indexes

Post by mark »

barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Updating of INVERTED METAMORPH indexes

Post by barry.marcus »

So to clarify, will chkind optimize the index once one or both of the thresholds in SYSMETAINDEX are met? Or does chkind somehow just send a notification that this needs to be done? Also, how would I run chkind in the background (as a service?) on Windows server?
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Updating of INVERTED METAMORPH indexes

Post by John »

Chkind will check the index every WAIT seconds, and if there are more than THRESH bytes of new or changed data it will optimize the index.

Chkind should run automatically, you can configure the settings for it in the [Chkind] section of texis.cnf/texis.ini.
John Turnbull
Thunderstone Software
Post Reply