Re: [basex-talk] Real time DB population using Nifi

Thanks Christian,

We are receiving from a repayable queue (Kafka topic), so the idea is if we replay the messages, the XML data is updated in the DB. We are taking the message ID as the file path. Basically:

clientSession.replace(messageId, XML file).

Juan

On Fri, 22 Dec 2017 at 11:41 Christian Grün christian.gruen@gmail.com wrote:

Hi Juan,

Welcome to the list and sorry for the late reply.

...

1. open db
2. replace (xml id path, inputstream)

Some suggestions:

1. If you can use ADD instead of REPLACE, you can usually safe a lot of

time.

2. If you need to replace docs, it may depend on what the "xml id path" is:

a) If it’s an attribute in the document, you may need to enable the updatable index (e.g. via the GUI, DBA, or the UPDINDEX option).

b) If it’s the database path, you could try to disable AUTOFLUSH, or provide us with more information on what you do exactly.

Best, Christian