We have a scenario where we need to have many columns inside a library, for which the drop-down values will be retrieved using look-ups from several lists. As we know there is a default threshold set by Microsoft '12' for number of lookups. For sure my need is much more than this threshold. I have read that each lookup is a join with a table(list in this case). So i need a suggestion from experienced sharepoint developers what is a better approach, lookups or direct adding choices for the dropdowns?
As I have heard that as the number of lookup increases, substantially performance decreases. But at the same point i don't want to make it hectic for my administrators later when the project is delivered, that every time they have to increase a choice they will have to add a hardcore choice to the columns rather than just adding an item to the existing lists.
Thank you in advance.