AnsweredAssumed Answered

Has anyone tried testing the storage limits of Portal?

Question asked by agelfert on Aug 14, 2019
Latest reply on Aug 21, 2019 by agelfert

Like • Show 1 Like1
Comment • 4

So I'm curious to see if anyone has tested to see how Portal performs as the number of items grow really large. A million anyone, 10 million?

As I understand it (correct me if I'm wrong), Portal is backed by a Postgres database for storing item metadata and file items as BLOB's. So it seems to me that Portal should be able to hold a lot of items.
Is anyone using Portal as a document management systems of sorts, i.e. storing non-spatial documents related to map features in Portal, that are tagged using a UID of whichever feature they relate to? I could envision a number of useful scenarios.

No one else has this question

Outcomes

JQuinn-esristaff

Aug 14, 2019 4:15 PM

When you upload content to Portal, the physical items are stored in the content directory and information about the item is stored in the database. The database doesn't store the item itself. Are you wondering about the performance of Portal when millions of items are in the Portal?

Actions

agelfert Aug 16, 2019 1:53 PM

Thanks for the clarifications. I had read the BLOB bit somewhere but I guess my own screenshot should've alerted me that the files go in the directory and only meta data goes in DB.

Yes, exactly. I was wondering how 100K's or 1M's of items would perform. Thinking now about all the necessary directory under the Content folder, that makes me even more curious. Say you have a 100K features, and each one has 10-100 documents... In the past, I've been told that if you want to link from spatial feature to related documents via href in the attributes, the associated files would have to live on the ArcGIS server ... so wondering if linking to Portal items would work better. Anyway, it's not something I'm about to implement. more brainstorming.

Actions

JQuinn-esristaff

@ agelfert on Aug 16, 2019 2:20 PM

We support the content directory residing in Azure BLOB storage, so perhaps that's where that came from?

There shouldn't be a problem in normal, day to day operations. Upgrading may take time as it needs to backup the content directory and reindexing will take time. But theoretically, yes, you could link to an item in the Portal rather than in a web server, (C:\inetpub\wwwroot, for example).

Actions

agelfert @ JQuinn-esristaff on Aug 21, 2019 7:30 AM

Thanks, Jonathan - good information.

Actions

4 Replies

JQuinn-esristaff Aug 14, 2019 4:15 PM
Mark Correct
Correct Answer
When you upload content to Portal, the physical items are stored in the content directory and information about the item is stored in the database. The database doesn't store the item itself. Are you wondering about the performance of Portal when millions of items are in the Portal?
Like • Show 0 Likes0
Actions
agelfert Aug 16, 2019 1:53 PM
Mark Correct
Correct Answer
Thanks for the clarifications. I had read the BLOB bit somewhere but I guess my own screenshot should've alerted me that the files go in the directory and only meta data goes in DB.
Yes, exactly. I was wondering how 100K's or 1M's of items would perform. Thinking now about all the necessary directory under the Content folder, that makes me even more curious. Say you have a 100K features, and each one has 10-100 documents... In the past, I've been told that if you want to link from spatial feature to related documents via href in the attributes, the associated files would have to live on the ArcGIS server ... so wondering if linking to Portal items would work better. Anyway, it's not something I'm about to implement. more brainstorming.
Like • Show 0 Likes0
Actions
- JQuinn-esristaff @ agelfert on Aug 16, 2019 2:20 PM
  Mark Correct
  Correct Answer
  We support the content directory residing in Azure BLOB storage, so perhaps that's where that came from?
  
  There shouldn't be a problem in normal, day to day operations. Upgrading may take time as it needs to backup the content directory and reindexing will take time. But theoretically, yes, you could link to an item in the Portal rather than in a web server, (C:\inetpub\wwwroot, for example).
  Like • Show 0 Likes0
  Actions
  - agelfert @ JQuinn-esristaff on Aug 21, 2019 7:30 AM
    Mark Correct
    Correct Answer
    Thanks, Jonathan - good information.
    Like • Show 0 Likes0
    Actions

GeoNet

The Esri Community

Has anyone tried testing the storage limits of Portal?

Outcomes

Related Content

Recommended Content