It's not as fast.

It is far more resources hungry when dealing with beyond 50 rows or more.

Puts needless pressure on backend.

It is not a good idea when sending whole dataset to client is feasible/better choice.