educative.io

How to get user photos without index on UserID?

Courses
,
#1

In this design photos are indexed only by PhotoID

So how we can get 100 last photos of a particular user?

Course: Grokking the System Design Interview - Learn Interactively
Lesson: Designing Instagram - Grokking the System Design Interview

#2

There should be an index on userId and CreationDate otherwise we cant fetch the news feed.

Course: Grokking the System Design Interview - Learn Interactively
Lesson: Designing Instagram - Grokking the System Design Interview

1 Like
#3

Hello Igor Batov,
Let me try to answer your query. Every photo has a user Id to know which user this photo belongs to and creation date to know when it was created. We can just fetch the last 100 photos user the userid and creation date
Hope this answers your query