We run CB 6.0.0 on a strong VM (m5.2xl) with 8 CPUs and 32GB RAM.
The server holds at the moment 30+ million short documents.
When running a simple
WHERE meta().id LIKE “PREFIX_NUMBER%”
the server responds after 50+ seconds at best. In many cases it doesn’t respond at all and exits with a time out.
This is by far extremely long execution time and is completely useless for production environments.
We’d appreciate help from indexing / querying specialists here to tune the server so that it will be useful and not simply eating our budgets.
Thank you all in advance.