is a "where in" clause with 1000 parts too much

is a "where in" clause with 1000 parts too much

If i want to create a page of status/message updates for a particular
entity, is there a better way to do it than this:
get all entities you follow/subscribe to
perform WHERE IN on status table.
My concern is: what if you follow 1000, 2000 entities? is that a problem?
whats the optimal way of doing this kind of data retrieval?