Big dataset not in filter
I have asked about this topic before but there are things I can't figure out.
I am setting up a structure similar to tinder. I keep the reactions of the users and the user id they reacted to in a table.
My flow is working now but it is obvious that it will have problems with large data. (We can think of a scenario where 1 user has 100 thousand reactions and the total number of profiles is 1 million).
When there is no more people to show this query to the client on the client side, the request is thrown. Therefore, it is not affected by table changes. It works like a rest api.
I have read all the articles but I cannot find a solution where I can use the index for this scenario. I have to filter, which leads to a full table search.
I am putting the sample code below. I would be glad if you help me.
I am setting up a structure similar to tinder. I keep the reactions of the users and the user id they reacted to in a table.
My flow is working now but it is obvious that it will have problems with large data. (We can think of a scenario where 1 user has 100 thousand reactions and the total number of profiles is 1 million).
When there is no more people to show this query to the client on the client side, the request is thrown. Therefore, it is not affected by table changes. It works like a rest api.
I have read all the articles but I cannot find a solution where I can use the index for this scenario. I have to filter, which leads to a full table search.
I am putting the sample code below. I would be glad if you help me.
