Service | Customer Service, Contact Center, Fie...

reduce Lookup Size

(0) Share

Report

Posted on by Be Elshayep

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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!
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:

https://learn.microsoft.com/en-us/power-platform/admin/capacity-storage.

https://learn.microsoft.com/en-us/power-platform/admin/add-storage.

https://learn.microsoft.com/en-us/power-platform/admin/add-storage

learn.microsoft.com/.../add-storage

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (1)

Report
Copy link

Link copied!
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:

https://learn.microsoft.com/en-us/power-platform/admin/capacity-storage.

https://learn.microsoft.com/en-us/power-platform/admin/add-storage.

https://learn.microsoft.com/en-us/power-platform/admin/add-storage

learn.microsoft.com/.../add-storage

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Be Elshayep 86 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Mohamed GRAIB 2,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Get Help + Support - Dynamics | Microsoft Docs

Was this reply helpful? Yes No
Be Elshayep 86 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No