This is probably a hard question to answer but how many Roles is too many when it starts to effect performance.
Our organisation is made of sports teams and there are over a thousand teams. Would it be a bad design idea to create a Role for each Team such as...
Team Manager of Manchester Eagles
Team Manager of Birmingham Bullets
Team Manager of London Lions
It could get messy.