Skip to content

Timeouts calculating project financials for a long-running completed project #37

@joshmcclain

Description

@joshmcclain

@anniesanctu hit a bug in Stacks that causes the project tracker to time out when viewing a completed project that lasted a long time. The actual length of the project isn't directly the problem, it's the number of Harvest Forecast assignments that causes the issue. We currently do a bunch of unnecessary duplicate queries against skill trees + finalizations when determining people's historical studio costs before expenses. We're doing that over and over for the same team members for each of their Forecast assignments over the lifespan of the project.

The code should be updated to prefetch all of the skill tree scores + finalizations for all the members of a project upfront.

dup_queries

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions