Please wait while we load your page...


Latest Version [8.00202307241] Last Updated [Jul-24-2023]

PasswordSentry Highly Recommends NETbilling

Optimize Performance Using LIMIT

Let's say you are searching the database for one row. You can optimize performance by adding LIMIT 1. Instead of scanning the entire database table(s), mySQL will stop scanning after it finds the first one. For example:

SELECT * FROM `users` WHERE `user` = 'jsmith' LIMIT 1

In the case of large database tables, the performance benefit can be large: in terms of time savings, and reduced load on mySQL server.
Live Chat Offline