With the growth of data on Greenstand, we are facing some challenges in the performance of our applications, including the web map and admin panel, so we consider denormalizing some critical data tables to solve the performance problem.
Some story and experiment on DB is here: https://github.com/Greenstand/treetracker-query-api/issues/277arrow-up-right
The new database table definition is here: https://www.figma.com/file/rbke28LussAy5VIp4rMsel/new-web-map-archetecture?type=whiteboard&node-id=517-184&t=advpqofQkoIa5z9x-4arrow-up-right
All tasks related to this project are here:
Thoughts on how to redesign the database, the architecture of how all these work, and the table details of the denormalized table.
Last updated 2 years ago
Was this helpful?
