AnsweredAssumed Answered

Document Creation performance issue

Question asked by devkinandanchauhan on Dec 24, 2018
Latest reply on Dec 26, 2018 by cesarista

I am using Alfresco Community Edition 5.0 and Postgresql 9.3.

 

In our application, we are creating all the documents in the root folder using cmis API.

This led to the slowness in the process of creating or updating the documents in Alfresco.

During document create/update, it is using below query which is taking 5 to 6 seconds to execute.

 

select assoc.id as id,
parentNode.id as parentNodeId,
parentNode.version as parentNodeVersion,
parentStore.protocol as parentNodeProtocol,
parentStore.identifier as parentNodeIdentifier,
parentNode.uuid as parentNodeUuid,
childNode.id as childNodeId,
childNode.version as childNodeVersion,
childStore.protocol as childNodeProtocol,
childStore.identifier as childNodeIdentifier,
childNode.uuid as childNodeUuid,
assoc.type_qname_id as type_qname_id,
assoc.child_node_name_crc as child_node_name_crc,
assoc.child_node_name as child_node_name,
assoc.qname_ns_id as qname_ns_id,
assoc.qname_localname as qname_localname,
assoc.is_primary as is_primary,
assoc.assoc_index as assoc_index


from
alf_child_assoc assoc
join alf_node parentNode on (parentNode.id = assoc.parent_node_id)
join alf_store parentStore on (parentStore.id = parentNode.store_id)
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)

where
parentNode.id = $id

 

I want to change the root folder(DB) of my alfresco from company home to some other folder.

Is there any configurations present which can help me in changing it?

Will this change resolve my problem?

 

Any other suggestions are most welcomed which can resolve the same.

Outcomes