I'm going to be taking a look at this permission issue over the next few days to determine what combination of steps we can take to make this significantly more scalable than it currently is. The comments above are very useful, and I'd like to ask people to contribute more ideas, more samples of problematic situations. Let's get all the data on the table and start thinking of a combination of:
- data model updates (if necessary)
- data model optimizations
- query optimizations
- usage guidelines
that will help us reach serious scalability.
