[Xapian-discuss] Xapian Search Index Continuous Update

[Olly Betts]

On Tue, Jan 16, 2007 at 05:42:57PM -0800, joe smith wrote:
> I have a database in mysql and have a table forum.
> Can xapian be configured to update continuously, and provide up to
> date result?

Yes.

I think you'll either need some sort of update hook called by mysql when
a change if committed (I don't know enough about mysql to know if it
provides this or not), or to add a call to the process which updates the
mysql database, or to just poll the mysql database for changes
frequently.  I'd imagine the same options apply to anything which isn't
actually built into mysql.

> Also, could the result made be sorted by time?

Yes, you just need to store the time associated with each document in
a document "value", then you can choose to sort on that value.

Alternatively, if documents are added in ascending time order, the
raw ordering of the documents can be used.  This often works well
for an archive of news stories, for example.

Cheers,
    Olly