Limit

In the lesson about LIMIT the lesson states that using LIMIT “…makes our queries run faster”

Is this really true?
I’ve been playing around a bit with my company’s database and have very similar fetch result times for 100 and 1000 entries for the same query. Row Camparison
Are there other factors that may be outweighing the benefit of LIMIT?

what about 10,000? or 100,000? Or even in the millions? Which is not uncommon. Databases can handle really large datasets.

also, the database is general only one layer within the application, so limiting the amount of data fetched might be very desirable.

1 Like

This topic was automatically closed 18 hours after the last reply. New replies are no longer allowed.