News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Why is my entity so la...

Customer experience | Sales, Customer Insights,...

Suggested answer

Why is my entity so large?

(0) Share

Report

Report

Posted on by simonsnell

117

We have an income entity in our system, which from our Dataverse storage use seems to average about 6.8k in size per record, compared to our Contact record (with many more columns) which only consumes on average 5.2k. We have 19m records, so are also looking to find ways to roll them up.

Can you think of why it might be so large, and ways we can reduce it?

We're considering:

- removing redundant columns

- moving data from multi-line columns to a new single-line text column.

Anything else you can think of?

Thanks

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

PerezAguiar on at

Like (0)

Report

RE: Why is my entity so large?

Hey!

Are any of those Multi-line columns used in search? Please have a look at https://learn.microsoft.com/en-us/power-platform/admin/capacity-storage#do-indexes-affect-database-storage-usage. Basically, when you need to "search" over a field, a set of indexes is generated. The more text, the biggest the index. If the multi-line field allows rich text, then instead of just saving the text, it will save everything as HTML code, which will add more characters to the storage (and to the index)

Regards,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans