topic Re: Document Creation performance issue in Alfresco Forum

Document Creation performance issue

devkinandanchau — Mon, 24 Dec 2018 09:19:34 GMT

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

Re: Document Creation performance issue

kintu_barot — Wed, 26 Dec 2018 13:48:32 GMT

Hi,

I don't think that changing destination path will resolve your problem.

Reference of compnayhome is used by other services of Alfresco as well, so it is not recommended to make any changes in Database.

However, using CMIS you can always change the path (from CompanyHome) to where you want to create / update the documents in Alfresco e.g. /Sites/test/documentLibrary/My Folder

Regards

Kintu

ContCentric

Re: Document Creation performance issue

ranjeetsi — Wed, 26 Dec 2018 15:58:53 GMT

Hi ,

Can you provide some more detail:

a) Using some client application - uploading/updating the documents? what is the client application based on java/python etc..? Also what protocol is used - REST- browser binding/REST atom pub/web services.

b) Can you check if database is causing the delay running a simple cmis GET query using cmisselector = properties or cmisselector =objects

c) Also is there any way you can profile the application using - Yourkit etc so that we know what exactly is taking time.

d) In the query - can you provide the noderef of the folder and not the path where you would like to upload the document.(and see if you get good performance)

e) Try to make direct REST call from POSTman or any REST client:

First get alf_ticket:

http://localhost:18080/alfresco/s/api/login?u=SSO4&pw=Password1
<?xml version="1.0" encoding="UTF-8"?>
<ticket>TICKET_c98c483f4ebd30f980d43b55e6a8e8c641a9c00b</ticket>

And then do a POST callas below screenshot)

http://localhost:18080/alfresco/api/-default-/public/cmis/versions/1.1/browser/root?objectId=edae3809-e4ce-4078-be02-059bf816dfec&cmisaction=createDocument&overwriteFlag=true&propertyId[0]=cmis:name&propertyValue[0]=fileNamet&propertyId[1]=cmisbjectTypeId&propertyValue[1]=cmis:document&propertyId[2]=cmis:secondaryObjectTypeIds&propertyValue[2]=P:cm:titled&propertyId[3]=cm:title&propertyValue[3]=TestFileTitle1&alf_ticket=TICKET_c98c483f4ebd30f980d43b55e6a8e8c641a9c00b

Just to ensure that login/getting ticket is 1st step and main upload is second step -

to identify if authentication is taking time.

Let me know if this helps.

Re: Document Creation performance issue

cesarista — Wed, 26 Dec 2018 18:00:58 GMT

Hi:

As advise, don't use / , better, place them under /MyApp/

Besides, you should distribute your documents uploads in some folder structure under your application rootpath.

There is a non-written rule that you should not have more than let's say 1000 documents in each level folder. Then your alfresco queries probably perfom better (or at least something better). Typical intermediate folder structures are yy/MM/dd based and the structure may depend on how many documents you upload per day.

Creation date based is valid for online daily uploads with no more than 1 thousand documents.

/MyApp/2018/12/26/doc1.pdf

/MyApp/2018/12/26/doc2.pdf

If you plan to some bulk upload some days, you can distribute them volume based:

/MyApp/Vol0001/ --> 1000 docs

/MyApp/Vol0002/ --> 1000 docs

Your application must create these hierchies via CMIS for example.

Regards.

--C.