AnsweredAssumed Answered

Referential integrity and performance of queries

Question asked by itsard on Jul 8, 2009
We are planning to integrate Alfresco DMS and RMS with our existing system.Our HR, Payroll and other common modules have a lot of complex applications.
Our concern is how would the relational database integrity be maintained in Alfresco database as it stores just the metadata for records
and the data being stored in the file system.Also, if there are too many records for an application, wont the metadata table
contain a lot many records affecting the performance in turn? and if we have to generate some complex reports on this data, where each field(Metadata) is stored in a other row,how it will affect the performance.

Outcomes