🌍💚 GREEN IT Developer: Limit the number of results

When possible, use the 𝑳𝑰𝑴𝑰𝑻 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 performance improvement will be even greater if the records contain many large fields.

When selecting, if you only want to display the first 25 records of a table containing people’s first and last names, replace the following:

𝙎𝙀𝙇𝙀𝘾𝙏 𝙛𝙞𝙧𝙨𝙩_𝙣𝙖𝙢𝙚, 𝙡𝙖𝙨𝙩_𝙣𝙖𝙢𝙚 𝙁𝙍𝙊𝙈 𝙥𝙚𝙤𝙥𝙡𝙚

with:

𝙎𝙀𝙇𝙀𝘾𝙏 𝙛𝙞𝙧𝙨𝙩_𝙣𝙖𝙢𝙚, 𝙡𝙖𝙨𝙩_𝙣𝙖𝙢𝙚 𝙁𝙍𝙊𝙈 𝙥𝙚𝙤𝙥𝙡𝙚 𝙇𝙄𝙈𝙄𝙏 0,25

With SpringBoot/JPA, do pagination 👉 https://lnkd.in/ecz8kkAG

#greenit #developer #resultsetlimit

Src.➡️http://www.ecometer.org/rules/limit-the-number-of-results.html