How to limit size of result set in doctrine 2?
Solution 1:
In Doctrine 2.1 method EntityRepository#findBy() now accepts additional parameters for ordering, limit and offset.
see full list new features in doctrine 2.1 (404)
Relevant link to findBy and findOneBy
example:
public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
usage:
$product = $repository->findBy(
array('name' => 'foo'),
array('price' => 'ASC'),
$myLimit,
$myOffset
);
Solution 2:
For Doctrine Query Language you have:
QueryBuilder::setMaxResults(integer $maxResults)