Skip to content

Optimize the User and Org API list views #658

@mitchelljkotler

Description

@mitchelljkotler

Both of these are very slow and mostly just time out. In practice, the detail view is normally used. To make these views operational, we need two things:

  1. Optimize SQL
  2. Cache the last 4 digits of the Org's CC number

The last 4 digits are currently fetched from Stripe, which means an API request per org, which gets very expensive quickly. The SQL could be optimized now, but if the API requests to Stripe are still in we will not see the benefits. This needs to be addressed once the Stripe updates are done.

Depends on #648

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