search

rajyraman / mscrmexporttoexcel

XrmToolBox tool to export all records from a view
MIT License
8 stars 15 forks source link

Experiencing slow performance after latest update #29

Closed sumitd1301 closed 2 years ago

sumitd1301 commented 2 years ago

@rajyraman This is a really helpful tool to export huge data of Dynamics 365 entity. However, the processing of the data fetch of the tool is rigorously slow after the latest update, and also, after a long run, it gives the connection a lost error. please look into it and make it work like before. Thanks!

beginner-luck1 commented 2 years ago

I have to admit, I relied a lot on this tool beforehand (without realising exactly how much) until the recent update which appears to have killed the exporting performance. Please look at fixing this tool, it was wonderful.

Thanks,

rajyraman commented 2 years ago

@sumitd1301 - I already rolledback most changes. The only one left to rollback is EPPlus to the older version. Would you be able to verify this, if I build a new version with older version of EPPlus?

beginner-luck1 commented 2 years ago

I'll be honest, if a "new" version is available to install via the "Tool Library" I will give it a shot for you. Unfortunately I am not in IT, so I can't "hack" install anything. My work laptop is locked down, and I am not a developer.

rajyraman commented 2 years ago

@beginner-luck1 - Tracked down the issue to a PR that I merged. The issue is caused due to Optionset value not cached. Fixed the issue in 3.0.3.

beginner-luck1 commented 2 years ago

Brilliant job, thank you, working as it used to. Thanks so much for this, it is greatly appreciated.

sumitd1301 commented 2 years ago

@rajyraman Thank you so much to fixed it, appreciate your promptness. It's working as expected and as before. @beginner-luck1 Thanks a lot to verify quickly. much appreciated.