Hi Alex, I agree that it would probably be unusual for a webpage to require that many rows that selecting the fields would matter. However, for any background tasks that might be running in the background of the app (maybe as a scheduled job), selecting specific fields can lead to a performance improvement.

In a project I’ve worked on myself in the past that I inherited from someone else, by defining the necessary fields in a query that was being run a scheduled job, I managed to gain a 45% speed improvement. Although there would be other ways to speed up the scheduled job that could give a better speed increase, this method is quick to add and doesn’t require any huge refactoring of methods.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store