How to handle more number of records in Gridview

Yii 2.0 General Discussions
1

Hi All,

   	I have one table which have approx 60 columns. It contains 50 millions rows. So when I display half of it records in Gridview, it takes lots of time in loading. Even when I search something in it, at that time also it takes more time(approx 3mins). How can I reduce loading time for more number of records?

Database is MySQL. I already applied indexing in Database. Also can’t change table structure.

Thanks!!

2

For searching: how long does it take in raw SQL?

3

It takes hardly 20-30 seconds in raw sql

4

Never had to display such amounts of data. Maybe SqlDataProvider can help performance?

http://www.yiiframework.com/doc-2.0/yii-data-sqldataprovider.html

5

Does it make sense to display or load millions of rows?!

Add some filter to your GUI so for example only the latest records get listed.