Forum OpenACS Development: Response to How to make an object type searchable?

Collapse
Posted by Clay Gordon on
Neophytos: I have a question about fts that I can't seem to find
and answer to, namely, how are indexes and unindexes
scheduled?

In the first instance, an object added to the collection is not
locatable by fts until it is indexed and the indexes updated. Does
this happen in real time (or real-enough time)?

In the second instance, an object deleted from the collection is
findable until the indexes are updated and all references are
deleted. In Verity, the index updating is a form of garbage
collection that, because it is slow, usually is scheduled
overnight. This means that queries will find objects that are no
longer in the collection for hours -- or longer, depending on when
the next update is scheduled.

Are you familiar with Texis from Thunderstone? It is an ANSI
SQL-compliant RDBMS that has been optimized for full text
applications. It is capable of running real-time news services,
with real time indexing and updating when items are added OR
deleted. This is an ideal situation. How close can we come with
fts?

Thanks,
Clay