guardian icon indicating copy to clipboard operation
guardian copied to clipboard

Appeal create take more time

Open singhvikash11 opened this issue 3 years ago • 1 comments

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

singhvikash11 avatar Sep 29 '22 12:09 singhvikash11

For this we will move from gorm and we can optimize the way we fetch data from the DB (utilize join, introduce index, etc)

mabdh avatar Sep 30 '22 09:09 mabdh