I am facing a design and UX issue while creating a master detail grid in which both master and detail can have over a million rows.

The simplest solution would be to enable paging (click) in both master and detail.

Can anyone suggest a better UI/UX design?

Thanks.