Thank you so much for reaching out! This is definitely an interesting case and I’m looking forward to helping you get the best solution for what you are doing.
The short answer is, you may see some performance degradation, but this performance slow-down will be only noticeable when you are trying to render your variable set within your browser. In other words, the performance of your endpoint machine, accessing the Octopus Deploy variable set page, will have some noticeable performance impact.
You should see no other degradation. The performance will still be reliant on your SQL servers performance and load at the time, but shouldn’t be significantly impacted by a 10,000 entry variable set.
I would love to hear more about this undertaking, as it’s not everyday that we hear about these sorts of expected numbers within variable sets. If you can provide some detail around the solution, I can run it past my team to see if we can brainstorm a solution that might result in a smaller variable set.
Otherwise, good luck!
Happy deploying and I would love to hear how it all goes.