Table looks like that:
Table is quite big so I don't want to download it all to my app memory.
Now in app I have a list of users and dates. There are max 1000 of them. Now I would like to make a query to check which of those users are not in a database. I can do it one by one byt it will be 1000 queries.
For example I have an object:
User:John, Date: 2000 so the query would be like:
Select * from Users where User = 'John' and DateFrom < 2000 and DateTo > 2000
so result is: John, 1900-01-01 9999-01-01
So it means that this user is ok but for object: User:Kyle, Date: 2005
result should be none so user is not ok.
WHat would be the best approach to get information about all my users in app in a n efficient way?