If a certain entity has many lookups, does this mean that the size of the data in this Entity will be very large?
if so, how can optimize the use of lookups in the entity
Thank You all guys...
I found that there is no way to do that.
instead, if anybody facing the same problem, I advise him to consider using the connections instead of Lookups and see if that helps.
Hi Partner,
As far as I know, there is no way.
Maybe you can create a support ticket for professional assistance following the below procedure.
I think that you cannot modify the size of the lookup field.
I'm so curious to know if there are a solution fo this.
Hi Leah Ju,
Thank u for your response.
but my concern is about the lookup size in database of the other table,
what I understand is that the lookup is save as an object of {entityType:"", entityName:"" , Id:""}
this could cost a lot of storage, So my question goes as Is there any way to reduce the lookup used storage?
Hi Partner,
The lookup is not just one field on the entity, when a lookup field is created, it also creates a relationship between the entity that the lookup is created for and the entity that is being looked up to.
The lookup field will list records another entity through lookup view, so you can filter the lookup view if you don't want to retrieve all record of the other entities.
Go to the views of the entity that is being looked up to, then find default lookup view:
Add filter you want:
https://www.forvis.com/article/2022/10/customize-lookup-views-in-microsoft-dynamics-365-crm
Hi Be Elshayep,
I am also interested to know these details related to the storage. As per my very little knowledge, there is no way to optimize lookups. Perhaps you need to take the decision whether to use choice, choices or lookups even text columns (but you will have a garbage data issue with text). There are some relevant threads:
Hi Be Elshayep,
I am also interested to know these details related to the storage. As per my very little knowledge, there is no way to optimize lookups. Perhaps you need to take the decision whether to use choice, choices or lookups even text columns (but you will have a garbage data issue with text). There are some relevant threads:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154