I see what you mean.... Thanks for the information Mark.... sounds to me like distributed lucene is the way to go in that case.

Regards,
</VJ>



On Mon, Jul 6, 2009 at 11:00 PM, Mark Robson <markxr@gmail.com> wrote:
I find the awkward bit is cleaning up cross-references, when you want to throw a row out of the main table, each of its indexes need to be cleaned up by a separate delete operation.