Skip to content
This repository has been archived by the owner on Oct 4, 2023. It is now read-only.

Improve Proposal queries to make them lighter #176

Open
idiom-bytes opened this issue Apr 7, 2022 · 1 comment
Open

Improve Proposal queries to make them lighter #176

idiom-bytes opened this issue Apr 7, 2022 · 1 comment
Assignees
Labels
Type: Enhancement New feature or request

Comments

@idiom-bytes
Copy link
Collaborator

idiom-bytes commented Apr 7, 2022

Problem:

Updating all rows inside Proposals is causing unnecessary load, and potentially leading to issues with executing other actions.
Also, we are currently experiencing more issues with timeouts, and all seem to be pointing towards heavy queries where we have not improved how we approach them.

Towards a solution:

In many cases there are optimizations that we can do, however we need to keep it manageable.

  1. Add a sleep or throttle of some sort to reduce load.
  2. Perhaps, only process individual projects that are submitting deliverables.

Constraint. KISS. Focus on migration to Mongo.

@trentmc
Copy link
Contributor

trentmc commented Jun 14, 2022

This is only worth doing if # proposals grows substantially. Probably not gonna happen in the near term since funding $ is not growing

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Type: Enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants