Index auto update

Wednesday, 22 August 2012 · 2 messages
GC
Gilles CARRY22 Aug 2012 14:34 #

Hello,

I'm a little bit confused with indexes auto update mechanism. Having created a DB with UPDINDEX=true, and after inserting nodes, 'info database' shows : Indexes Up-to-date: false Text Index: ON Attribute Index: ON Full-Text Index: OFF

whereas UPDINDEX=true. After issuing 'optimize', Up-to-date come back to true and FT index to ON.

Does this mean index are not automatically updated if 'optimize' is not run?

I use BaseX73-20120528.232116.jar

Is there any comprehensive documentation about index update mechanism?

Thank-you, Gilles.

CG
Christian Grün22 Aug 2012 15:08 #

Hi Gilles,

Quoted text · Gilles CARRY · 1 line
> I’m a little bit confused with indexes auto update mechanism.

our incremental update feature is still work-in-progress, which is we haven’t included it in all interfaces yet (e.g., the GUI). However, the existing functionality is well-tested and has proven to be stable. As the info command shows, text and attribute indexes will always be up-to-date. In the final version, the full-text index and database statistics will be updated, too (and the output will be less confusing).

Quoted text · Gilles CARRY · 1 line
> Is there any comprehensive documentation about index update mechanism?

Dimitar’s master thesis will give you in-depth information on how incremental updates work:

http://files.basex.org/publications/Popov%20%5b2012%5d,%20Advanced%20Storage%20Structures%20for%20Native%20Databases.pdf

Some more hints (which you’ve probably already seen) are given in our documentation:

http://docs.basex.org/wiki/Indexes#Value_Indexes http://docs.basex.org/wiki/Options#UPDINDEX

Best, Christian

Quoted text · Gilles CARRY · 42 lines
> Having created a DB with UPDINDEX=true, and after inserting nodes, ‘info > database’ shows : > > Indexes > > Up-to-date: false > > Text Index: ON > > Attribute Index: ON > > Full-Text Index: OFF > > > > whereas UPDINDEX=true. > > After issuing ‘optimize’, Up-to-date come back to true and FT index to ON. > > > > Does this mean index are not automatically updated if ‘optimize’ is not run? > > > > I use BaseX73-20120528.232116.jar > > > > > > > Thank-you, > > Gilles. > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

⚡Generated with XQuery