How to paginate a findAll() query?

Yii 1.1 General Discussion
1

Hello there!

Im having trouble setting this up, how do i effectively set a pagination in a findAll() query?

Currently, i have a single query which can have thousands of results and im hitting the limit if that quantity is reached, yet i still need to get all rows from the database to do an operation with them.
How do i set a pagination limit so it does whatever it needs to do (be it an INSERT, UPDATE or smth) in a set limit? (eg: insert 100 rows at time from 1000 using findAll results, until all 1000 rows have been inserted)

2

Hello.
You can use count() first:
query builder: count()
then limit() and offset() in your select queries:
query builder: limit() and offset()
This way you can easily cut whole job into batches choosing batch size whatever you want.