feature: redundant sql queries #132

New issue

Open

opened 2026-02-23 19:13:15 -06:00 by noe.trevino · 0 comments

noe.trevino commented

2026-02-23 19:13:15 -06:00

Owner

Did you check the docs?

I have read all the paso docs

We are most definitely make more queries than we need to. As the application was being developed, sometimes sending another query to the database was a naive solution. There might be parts in the database that could benefit from a thorough look through to see if we aren't making x queries where less would suffice.

Describe the solution you'd like

Solutions can include:

make a more specialized query. Something like "GetTaskDetailsWithStandupInfo"
n+1 queries? Probably not but need to comb through codebase
explain plan all queries
any missing indexes?

Acceptance Criteria

optimizes fetches throughout the codebase

Describe alternatives/other solutions you've considered

No response

Additional context

No response

### Did you check the docs? - [x] I have read all the paso docs ### Is your feature request related to a problem? Please describe. We are most definitely make more queries than we need to. As the application was being developed, sometimes sending another query to the database was a naive solution. There might be parts in the database that could benefit from a thorough look through to see if we aren't making x queries where less would suffice. ### Describe the solution you'd like Solutions can include: - make a more specialized query. Something like "GetTaskDetailsWithStandupInfo" - n+1 queries? Probably not but need to comb through codebase - explain plan all queries - any missing indexes? ### Acceptance Criteria optimizes fetches throughout the codebase ### Describe alternatives/other solutions you've considered _No response_ ### Additional context _No response_