When possible, use the LIMIT statement to specify the number of results to return. This helps minimize the amount of CPU and RAM used to find the relevant records.
The improvement in performance will be even greater if the records contain many large fields.

The amount of time a user spends on a website or an online service is the most significant factor in reducing or increasing the website’s environmental footprint. In other words, the less time the user spends on the website or online service, the smaller the environmental footprint.
You must therefore try to minimize the number of screens, steps and unnecessary interactions while at the same time ensuring that screens are not overloaded and too complex, which in itself can be counter-productive.