lucky-parking icon indicating copy to clipboard operation
lucky-parking copied to clipboard

[DRAFT] Implement Redis in our backend to optimize queries on repeated requests

Open macho-catt opened this issue 3 years ago • 2 comments

Overview

We need to optimize queries to our database by caching repeated queries.

Action Items

  • [ ] Review how Redis works, and discuss with the team if it is necessary, or if there are other viable caching solutions
  • [ ] Gather data on how long each query (and repeated queries) on the database takes
  • [ ] Implement Redis on the backend
    • [ ] Gather new data on how long repeated queries take with the caching solution
    • [ ] Demo to the team / lead
  • [ ] Open a PR to implement Redis

Resources/Instructions

https://github.com/redis/node-redis

macho-catt avatar Feb 10 '22 23:02 macho-catt

Putting this in icebox for now, as there are possible optimizations on the frontend and the aws instance to host this on would not have enough storage / memory.

macho-catt avatar Mar 16 '22 05:03 macho-catt

This issue is a DRAFT for now, but anyone can update the sections based on the format below, especially the Overview section. Once we know what needs to be done and why we can prioritize whether to work on this issue.

Dependencies

ANY ISSUE NUMBERS THAT ARE BLOCKERS OR OTHER REASONS WHY THIS WOULD LIVE IN THE ICEBOX

Overview

WE NEED TO DO X FOR Y REASON

Action Items

A STEP BY STEP LIST OF ALL THE TASK ITEMS THAT YOU CAN THINK OF NOW EXAMPLES INCLUDE: Research, reporting, etc.

Resources/Instructions

REPLACE THIS TEXT -If there is a website which has documentation that helps with this issue provide the link(s) here.

gordonruby avatar May 02 '22 16:05 gordonruby