topic Re: Store large data in Alfresco Archive

Store large data

maksimov — Thu, 28 Apr 2016 05:53:15 GMT

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

Re: Store large data

maksimov — Fri, 29 Apr 2016 07:52:49 GMT

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

Re: Store large data

kaynezhang — Fri, 06 May 2016 08:32:45 GMT

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.

Re: Store large data

steven_okennedy — Mon, 09 May 2016 13:18:45 GMT

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