Doctrine 2.2 + Zend Framework pagination speed optimization

I'm struggling with Doctrine 2 performce when using HYDRATE_OBJECT. When I switch from HYDRATE_ARRAY to HYDRATE_OBJECT, it takes nearly 10 times longer! I've used doctrine 2 and zend paginator as reference:

$query = $em->createQuery($dql)
    ->setHydrationMode(\Doctrine\ORM\AbstractQuery::HYDRATE_ARRAY)
    ->setParameter('x', 1);

// Pagination
$paginator = new Doctrine\ORM\Tools\Pagination\Paginator($query, false);
$iterator = $paginator->getIterator();
die(); // 160 ms

vs

$query = $em->createQuery($dql)
    ->setHydrationMode(\Doctrine\ORM\AbstractQuery::HYDRATE_OBJECT)
    ->setParameter('x', 1);

// Pagination
$paginator = new Doctrine\ORM\Tools\Pagination\Paginator($query, false);
$iterator = $paginator->getIterator();
die(); // 1.4s

What should I watch out for? How to reduce the processing time and still utilize HYDRATE_OBJECT? Is there a better way to accomplish pagination?

*Edit: Using ->setFirstResult($itemsPerPage * $page - $itemPerPage)->setMaxResults($itemsPerPage); significantly decrease loading time, but when using $iterator:

$adapter =  new \Zend_Paginator_Adapter_Iterator($iterator);
$zend_paginator = new \Zend_Paginator($adapter);          
$zend_paginator->setItemCountPerPage($itemsPerPage)
    ->setCurrentPageNumber($page);

Zend only knows about $itemsPerPage, (count($iterator) == $itemsPerPage) and thus the pagination links always calculate 1 page only. How can I accomplish a proper pagination using Zend_Paginator, and only load $itemsPerPageentities?

Answers


I solved this now by creating a Zend pagination adapter wrapper for Doctrine pagination;

<?php
class PaginatorAdapter extends Doctrine\ORM\Tools\Pagination\Paginator implements
        Zend_Paginator_Adapter_Interface
{
    public function getItems($offset, $itemCountPerPage)
    {
        $this->getQuery()->setFirstResult($offset)->setMaxResults($itemCountPerPage);
        return $this->getQuery()->getResult($this->getQuery()->getHydrationMode());
    }
}

Need Your Help

How can I write javascript tests that don't timeout or fail randomly with rspec, capybara, and poltergeist?

ruby-on-rails rspec capybara bdd poltergeist

I have been having problems with my tests timing out and failing randomly. I have been looking around for best practices of how to write robust capybara integration tests but I don't find anything

httpUrlConnextion.getContentLength returning incorrect value

java android json url httpurlconnection

HttpURLConnection connection =(HttpURLConnection)blogFeedUrl.openConnection();