I'm just recently using the paginator and I also ran into this problem. I had to do multiple selects on e.g. all my users
$userModel = new UsersModel(); $users = $userModel->fetchAll()->toArray(); foreach($users as &$user) { //... do other selects and add data to users; } // put everything in the paginator This can become very time consuming when you got a lot of users and only want to display 10 each page. But I didn't find a way around. So if anyone has a suggestion... Martin Martinov-2 wrote: > > But doesn't this mean that if I have let's say 12 000 rows in my > table, I have to fetch all of them just to display a very little part. > That's big overkill I think. The table I have in mind gets around 100 > new records each day. What happens when the records count becomes say > 200 000? > ----- visit my website at http://www.phpscriptor.com/ http://www.phpscriptor.com/ -- View this message in context: http://www.nabble.com/Zend_Paginator-Question-tp21931445p21933193.html Sent from the Zend Framework mailing list archive at Nabble.com.