22 Oct
2018
22 Oct
'18
1:46 p.m.
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