
Hi !
Recently, I've been developing APIs with Power Automate to query our Dataverse (CRM) data from third-party applications. I don't have any issues with my data queries; everything is functioning correctly.
However, I'm encountering performance issues that I can't seem to understand. Sometimes, when I call my HTTP trigger, it takes 2 seconds to execute; other times, a Dataverse query takes 20 seconds, and then the next call takes less than 1 second. These events seem random to me, and I can't explain these performance problems, which greatly impact our third-party applications querying our Dataverse data.
I've searched, but I haven't found any settings to adjust.
Does anyone have any ideas on how to improve these performance issues? Or perhaps there's nothing we can do..
Thanks in advance!