Grid very slow.. 10 Lakhs Records.

Applications Grid / Reports
#1

Hi Friends,

        I have 10 Lakhs records in Grid. I showed per page 15 records and i used 3 Nested Grids. It will take more time(minimum 2 minutes). I created indexed in mysql tables. The first time i clicked the menu.. It will take more time.. 

       I used SCRIPT CASE VERSION 7.1

    Please give me the solution. Very Urgent.
#2

I think that the issue is in the nested grids. It might be that you have 10 records, but if these 10 records each have a lot of nested data which in turn also has… The cartesian product might be that there’s a lot of IO involved. It’s good to have looked at indexes but try to look at the access plan of MySQL to see if the indexes are actually used. But initially all your data is in your webform so that when you open a subgrid you don’t have to access the server. But in this case that exactly might be the problem.

#3

Hi Aducom,

                    Initially Grid shows (10 Fields) and 3 Nested Grids. Totally 4 tables i used and i made mysql indexes everything. per page 15 records. If click the menu it's showing parallel download one by one records is downloading the page... Give any suggestion.