How to handle more number of records in Gridview

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.


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

It takes hardly 20-30 seconds in raw sql

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

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.