Ma77Ball opened a new issue, #5645: URL: https://github.com/apache/texera/issues/5645
### Task Summary `ComputingUnitAccess.getComputingUnitAccess(cuid, uid)` performs two separate DAO lookups to resolve a caller's privilege on a computing unit: it fetches the unit by `cuid`, then fetches *all* of the user's access rows by `uid` and filters them in memory for the matching `cuid`. This is an N+1-style access pattern, and the in-memory filter scales with the user's total number of access grants rather than the single row needed. It should be a single query: a `LEFT JOIN` of `WORKFLOW_COMPUTING_UNIT` to `COMPUTING_UNIT_USER_ACCESS` on `(cuid, uid)` returning the owner uid and the caller's privilege in one round-trip. ### Task Type - [x] Performance -- 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]
