Problem With Pagination


I have a CListView, and for it is passed a CActiveDataProvider that received data from a table that have more than 3.000.000 lines …

But when I try to load the view, this takes more than 1 minute, even if I put pageSize of 1.

I try to load the table using limit by findAllBySql, and takes just 0.5 seconds to load, someone can help me with this?


Try with pagination concept… may be it can work