FourFriends opened a new issue, #6238: URL: https://github.com/apache/gravitino/issues/6238
### What would you like to be improved? in java/org/apache/gravitino/storage/relational/service/RoleMetaService.java function listSecurableObjects need to improve performance when roles is bound to many metadata, in our company, a role usually is bound to 1000+ metadata (such as fileset or table)， when there are a lot of filesets, this function run very slowly due a lot of visiting table . ### How should we improve? 1. batch visit metadata table instead of visit table one with a fileset 2. or use cache 3. or use metadata id instead use metadata name -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
