On 10/21/2019 7:59 AM, Vincenzo D'Amore wrote:
But how many dynamic fields like this can I have? more than thousands?
There are no actual limits on the number of fields, dynamic or not. You can have as many fields as you want per document, and as many fields as you want across the whole index.
But as soon as you start wondering whether Solr can handle thousands of anything, chances are good that there will be a performance wall. Unless it's total document count in the index, which readily scales to billions if the hardware is sized approriately. It takes time to iterate through parts of the index that are large, and not all aspects can be accelerated by clever programming.
Thousands of fields per document would be harder for Solr to handle than thousands of total fields across the whole index, but I would expect the latter to eventually be a problem for some aspect of Lucene or Solr.
It is also possible that you can use thousands of fields and never see a problem. But we have seen it cause issues, so it's generally not recommended.
Thanks, Shawn
