[basex-talk] Fairlock and query monitoring

Hi, for some time now, I've switched a production system (running Basex 8.6) to FAIRLOCK = true. With PARALLEL = 16.

While this helped speed up write operations, there are situations where queries go from sub-second to minute(s) if a few more users are reading/writing at the same time.

The DBs in question are incrementally indexed.

Since single queries are fast, I don't know what the best way of handling these situations would be.

As a last resort I was thinking about adding a cache solution (write-behind) that allows for saving and delays (batches) writes.

But before introducing another component to the system, I'd like to hear what other ideas might exist.

Br, Max