Dynamics Community Forum Thread Details

Challenges with Custom Entity Performance in Dynamics 365: Seeking Expert Advice

I am currently facing performance issues with a custom entity in Dynamics 365. This entity has a large number of records and complex relationships with other entities. The main problems arise during data retrieval and when executing workflows that trigger business rules and automation.

Here are my specific questions:

Data Retrieval: What are the best practices for optimizing fetch operations on large datasets within custom entities in Dynamics 365?
Workflow Efficiency: How can I improve the performance of workflows that involve this custom entity, especially those that trigger multiple business rules and automations?
Indexing Strategies: Are there specific indexing strategies that could be implemented to enhance query performance on custom entities?
Architecture Considerations: Would implementing a different data architecture, like splitting the entity into smaller, related entities, help improve performance?
Additional Context:

We often experience timeouts and slow response times during peak usage hours.
The system is cloud-based, and we primarily use OData for data operations.

Quick Links

Leaderboard