Hi all,
we have two Linux server VMs where our BaseX application is running
- Integration - Production
The used database is about 5 GB including a fulltext index and is identical on both systems.
The production VM is more potent in all aspects (CPU, RAM, Disk IO, ...). Dispite all of that we do not get any significantly better performance in the production system.
On top of that we even have XQuery requests that sporadically take very long (> 1 minute) that would normally take only less than one second. Again these long requests only happen in the production environment.
My first assumption was that maybe it is due to additional load on the server from other sources. But that was not the case. We have the spikes even when there is no load at all.
Has anyone similar experiences or any ideas what could be the cause for this behaviour?
Best Regards Johannes