Export to excel for large data set which is to be retrieved from 2 data entities

I have a need to use export to excel functionality feature for a report where data is supposed to retrieved from multiple(2) cdt.

Also, the dataset is extremely large.

What approach should i go for?

 Discussion posts and replies are publicly visible