We are using Alfresco 2.1 (community edition) to handle a repository of several million documents. In the process of loading data, we found several indexes missing from the database, whose absence was causing some full table scans, and hence significantly slowing processing. This did not noticeably reduce performance in our ~1000 document test environment, but crippled our full-volume environment.
In a quick search of the forum posts, I could not find any other posts relating to missing database indexes. Has anybody else has encountered this problem? Are the missing indexes (and other performance improvements) provided with the Enterprise Edition?
The indexes we created to resolve our performance problems include:
Table alf_node_aspects. Created a primary key on node_id and qname (no primary key was present)
Table alf_child_assoc. Created index on child_node_id.
Table alf_child_assoc. Created index on parent_node_id and qname.
Table alf_node_status. Created index on transaction_id
