[Sample] Rewrite Query Caching Logic
Created
May 12, 2021
Type
Status
Epic
Sprint
Priority
Tasks
Timeline
Product Manager
Engineers
Create a new item in your database and choose
Task from the list of template options to generate the format below. Learn more about database templates here.Overview
Problem statement
Describe the problem you're trying to solve by doing this work.
Our Postgres queries are currently cached, but the performance is subpar and is causing slow load times on the front end.
Proposed work
High-level overview of what we're building and why we think it will solve the problem.
Research and implement a new caching strategy.
Success criteria
The criteria that must be met in order to consider this project a success.
- Load times reduced at least 20%, ideally more
- CPU usage decreased
User stories
How the product should work for various user types.
As a user
- I want my search queries to return results quickly
- So I can get my work done faster
As a front end engineer
- I expect my queries to be cached on the back end
- So the front end can be as fast as possible
Scope
Requirements
Current project requirements.
- Plan and implement new database caching strategy
- Create a testing and deployment plan
- Improve monitoring tools
Future work
Future requirements.
- Monitor caching performance
Non-requirements
List anything that is out of scope.
- Front end caching