nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Store large data

maksimov

Hello!

I'm using Alfresco Community v 5.1. I want to store files with a large amount of related information. I have to create many different types of documents with dozens of properties for each. May be several hundreds such entries per day. How is these views (document types with properties) stored in the Alfresco database?. How I should organize storage and what about performance in this case?

Thank you!

Find more posts tagged with

Comments

maksimov

Dear colleagues, the question is very urgent! Please help with the decision!
Thanks.

kaynezhang

When a file is uploaded to the Alfresco it is stored on disk in a special directory structure that is based on the date and time of the upload.
The file's metadata(properties） is stored in an RDBMS .
Indexes are stored on the disk.

steven_okennedy

Hi Maksimov,

A key consideration here is how many of the dozens of properties do you intend to be searchable? Alfresco stores data in 3 key areas: The content store (filesystem) for the physical content (e.g. document itself), the Alfresco database for the metadata associated with the content (including properties, associations, workflow instances/details/history, audit information, users, groups, ACLs) and lastly Alfresco uses Apache Solr for indexing the content and any searchable metadata and associated permissions (in Lucene indexes also on the file system)

The sizing of the indexing elements (ensuring Solr has enough resources/CPU/RAM etc) are just as key to fast performance as the tuning of the database and the Alfresco repository

Regards

Steven