Hi Bright,
We had this problem too. What we did to increase export performance is use the OQL Module. In there is an export to CSV function. So you need to retrieve your data over OQL and export it to CSV.
Kind regards,
Steven
I'd suggest using the Advanced Excel module and creating the export manually with microflows, you can further optimize the export that way.