Hi,
There is limit on the number of buckets we can create. Is there limit on the number of Full Text Search Index we are allowed to create? or any best practice or performance guideline on the maxi number of FTS Index? Thanks.
There isn’t one such limit on the number of FTS indexes one can create. Note that all these indexes would be sharing resources, so this is more of a sizing question. Here’re some relevant questions …
- how many indexes do you intend to create?
- what is the size of the data you want indexed?
- how many query operations do you expect, and how many during live index build (with continuous mutations)?
- what resources do you have at hand - RAM/CPU/DISK available?
Hi, @abhinav,
Based on the information you provided, there is no hard limit on the number of FTS indexes then. The performance of the query and indexing the FTS Indexes will depend on the availability of the resources (e.g. RAM/CPU/DISK). If we found the FTS indexes causes the system not perform, by adding more resources will resolve the issue. Please let me know if I have the incorrect understanding. Thanks.