The post mentions sharding by userid and videoid. So how can search be efficient in this case if I search by video titles?
We cannot run a query like select * from videos where title like '%xyz%'
right?
The post mentions sharding by userid and videoid. So how can search be efficient in this case if I search by video titles?
We cannot run a query like select * from videos where title like '%xyz%'
right?
In this lesson, when we mention searching by title, we are not mentioning this is an efficient searching method. We are simply stating another way of searching for videos on all the servers.
An efficient way would definitely be using UserID or VideoID, depending on whether the database is user-populated or video-populated.
Thanks,