Performance concerning categories
Hi, I was wondering what impact having a large volume of categories might have on overall performance of vanilla forum and in what areas performance would degrade as category count balloons. My intent is to allow a private category to be automatically created for each user, and for overall topic count for each user to be 1,000+ with 10-100 posts in each topic. My goal is for user count to be in the 10,000s to possibly 100,000+ .
I'm not looking for more than a general guess since so many variables can come into play such as frequency of user activity etc, but I don't want to go down this road if it's likely to cause my database performance to significant degrade.