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!

[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