Most services don’t handle ddos amounts of data, a few 1000 rows of data is fine.
Don’t design like you are Twitter if you are not. It is a waste of man hours. If I as a client need 10 000 rows of data that is what I will ask for either in one request or in a 100 consecutive.