You can bring anything to its knees when requesting too much data at once. There's always another bottleneck. Getting all data in a single request is an antipat

You can bring anything to its knees when requesting too much data at once. There's always another bottleneck. Getting all data in a single request is an antipattern to me. Fetching a lot of data unless absolutely necessary with no other option is an antipattern to me. But that of course is relative to a specific purpose.