What is the most optimal way to do this?
- In TV Show page I need to get all progress from all episodes in that TV Show
- In Homepage I need to get the continue_watching
- In Episode I need to get progress of the episode.
- Some TV Shows have more than 100 episodes
Ex:
USER_ID | SHOW_ID | LAST_SEEN_ID | LAST_SEEN_TIME
10 | 5 | 12 | ---
USER_ID | EPISODE_ID | PROGRESS
10 | 10 | 15
10 | 11 | 20
10 | 12 | 95
OR
USER_ID | SHOW_ID | PROGRESS | LAST_SEEN_ID | LAST_SEEN_TIME
10 | 5 | {"10":15, "11":20, "12": 95} | 12 | ---
In PosgreSQL I can get the individual progress with:
SELECT progress->'10' as progress...
I think that the best method is the first but it will create a lot of rows and this could make DB slower?
Asked by Angel Vega
(11 rep)
Apr 1, 2020, 11:10 PM
Last activity: Aug 5, 2025, 08:04 PM
Last activity: Aug 5, 2025, 08:04 PM