What are theoretical and practical limits for the number of plain tables I create? Would it be ok to have hundreds of them? Or thousands? Can Manticore deal with a configuration file with 50,000 “table” entries?
The only limit I am aware of (other than actual RAM limits, each index will require RAM)
… is the file descriptor limits, typically imposed by the host OS. searchd needs to open a number of files for each index.
… you can configure it so doesn’t just blindly ‘open’ all indexes on startup, only opening when first needed. But I believe once open it remains open.
So would the number of indexes ‘used’, rather than exist in config file that technical limit.
Might be able to configure searchd to have a much higher file descriptor limit, but dont know its effect on the OS.
(I’ve worked on functional installations with ‘hundreds’ of indexes, not thousends)