Hi

Does anyone knows if the LIMIT inside a select query improves queries performance?

depends on the query

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 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.