Answered

What is the difference between database capacity and file capacity

(0) Share

Report

Posted on by BollGary

I have one question, may be very stupid question. I always used the SharePoint list as my data source, and have no any experience of using Dataverse, now, I am trying the first time to connect Dataverse, everything is fine.

I created one new environment, and get the below capacity:

8.66GB database capacity

50GB file capacity

2GB log capacity

Which make me some confusion, what is difference between database and file, for example, I created one table and this table include one image type column, my apps take photos and store them into this image column, What capacity are these photos consuming? The below statement I got from Microsoft, it mentions both? I can't understand.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @BollGary ,

The image and file columns and any attachments in Note entity are all using the File capacity vs. the Database capacity.

These are at least the ones you would notice at all.

Was this reply helpful? Yes No
BollGary 87 on at

Like (0)

Report

Thanks a lot for your answering, can you help to explain a little more? The capacity for database is only 8.66GB, but file capacity has 50GB, if I store 1pcs photo, size is 10MB, how much capacity consumed in database, and how much consumed in file? What is the allocation plan? This is very important for me to make my purchasing plan, I noted it is very expensive to get more database capacity.

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @BollGary ,

Detailed calculations within Dataverse on storage is not well documented. I have answered the question to estimate storage of records in the table storage here (https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Storage-calculation/m-p/1382805).

From a file perspective, if you upload the photo that is 10MB this will be in the File storage, not the Database. There will be minor (very minor) usage for some tables to be file pointers but that is about it.

Overall if you have a lot of images / files you should still look at externalizing this with SharePoint or even with Azure Blob storage. Eric provided some good details on this (https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-to-integrate-Azure-blob-storage-with-dynamics-365/td-p/843626)

Was this reply helpful? Yes No
BollGary 87 on at

Like (0)

Report

Thanks, it make me better understand, yes, I plan to put so many photos in Dataverse, maybe 20GB capacity consuming per year, just now, I found I am out of date, I just found SharePoint has support image column, because I always use base64 to store image in the text type column in SharePoint list, which is so slow, then I want to change data source from SharePoint to Dataverse, just now, I found the below link, and checked it in SharePoint list, I found the image type column, that is great, and also thanks a lot for sharing your knowledge.
Power Apps can now display images from SharePoint Online/Microsoft Lists – Ganesh Sanap Blogs (wordpress.com)

Was this reply helpful? Yes No
BollGary 87 on at

Like (0)

Report

Oh, no, I found Power APP still can't directly display the image column in SharePoint list, I found Microsoft has pushed back several times for this feature.

Was this reply helpful? Yes No