var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LIMIT improves query performance?
Does anyone knows if the LIMIT inside a select query improves queries performance?
it is a select query that refers to large tables that refers to "products
The query is searching for products with certain criteria. (price, category,manufacturer).
Could you be more specific on what it depends?
It would have to
It would have to improve server performance and query performance. Processing 100 records instead of 100,000 by using limit is definitely going to be a performance gain.
So I think it depends on the number of records you expect to get from your query. Of course if you query for record where ID=1 then LIMIT is superfluous.
Tags for this Thread