yuqi1129 commented on PR #6601: URL: https://github.com/apache/gravitino/pull/6601#issuecomment-2712535655
> Although we batch object ids in same SQL queries, For the child metadata object, We still have to fetch id and names of parent object, this is similar to N+1 problems in GraphQL. > > Does Gravitino has some cache / data loader mechanisms to solve this? > > [apollographql.com/docs/graphos/schema-design/guides/handling-n-plus-one](https://www.apollographql.com/docs/graphos/schema-design/guides/handling-n-plus-one) We will add a global cache mechanism to resolve this problem completely; optimizing database operations can only alleviate but not solve it. -- 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]
