guardian
guardian copied to clipboard
Appeal create take more time
Description Appeal creation starts taking more time as policies, and grants grow. One of the reasons is that we load all the policies, grants, and providers instead of the id by query on (policy id, policy version), resource id etc.
Expected behavior The appeal creation API shouldn't take more than ~ 40-50 ms
For this we will move from gorm and we can optimize the way we fetch data from the DB (utilize join, introduce index, etc)