Max number of collections / indexes with PerconaFT

I’ve tried to find the information myself but I couldn’t, so here it goes:

What is the max number of collections+indexes a single node can have when using PerconaFT? WiredTiger uses file per collection + file per index, which effectively limits the amount substantially. RocksDB works well for huge numbers (N millions), and I would like to confirm PerconaFT engine’s technical limits on this.

Hi Flozano,

By default its 24000 names spaces in the 16 MB file, also each collection can only have 64 indexes. This means if you have 1 index per collection you can have 24k collections but at 64 indexes per collection you can have 375.

I hope that info helps you.

regards,