3043 ms peak average - MVS Export CDT to Excel (0005e34f-02ca-8000-6ee0-010000010000) -> Export Data Store Entity to Excel ( Health Check report)
Export Data Store Entity to Excel smart service is taking too long to convert what will be the alternative of this service to replace with.
Discussion posts and replies are publicly visible
Why is this a problem? The only alternative, I think, is to directly export from DB to Excel. But then you have less options.
We are exporting less data still taking 3043 ms peak average it will fail on real time data so what will be the best posible case to reduce time?
How much time does the same query take to execute using query entity?
Did you consider to create a view in the database with the exact structure as you need in the Excel, and then export this?