155
My org. are looking into virtual entities. Our primary goal is to gain performance as our experience is that the DB in Dynamics Online is really slow.
What are your experience of virtual entites when it comes to performance? Is it more slow, same or faster then a "normal" entity?
Hi Kranis, thanks for reaching out.
No one is going to dispute the speed of the online system is not ideal. Hard to get the flexibility, configuration and customization abilities all in one system while remaining fast and responsive. Good news is it gets better with each version.
Virtual entities are difficult to implement. They require the source to have a GUID as a PK, which most sources do not have. They work best when anchored to another entity, not as the primary entity. Hard to reference child entities to a parent entity when the parent is virtual since data is not in the system.
Performance wise would depend on the source connection, and internet connection between source and D365 data center hosting your instance. In my opinion there is rarely a scenario where pulling data from another system would be faster than pulling data from within D365. The speed is not related to the database it is related to the UI which D365 provides, also customizations on the UI make this more difficult, plugins, etc also complicate the issue.
Hope this helps. Have a great day!
Hi kranis,
Accessing Virtual Entities must be slower than normal entities which even depends on the VE Exteranl DB Location.
From the following VE Data Translation architecture screenshot provided from MS , the External Data provider provide the DataSet to localized Organization DB. The normal entities gathering speed in local Organize DB must be faster that the Virtual Entities whose data is in External DB. You could refer to the official doc for more details about VE's other advantage.
[View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/create-edit-virtual-entities:750:50]
Hope the above would help.
Regards
Johnny
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (