topic Getting CMIS connection performance issue in Alfresco Archive

Getting CMIS connection performance issue

eleman304 — Wed, 25 Jul 2012 08:27:34 GMT

Hi all,I have performance issue when getting cmis connection from alfresco.Getting connection takes 10 mins for Atom bind and webservice bind. (upload document takes 2 sec. per document)Is it normal ? Is there any way to improvement connection performance ?Env.- Alfresco 4.0c- OpenCmis- Mysql 5.5.25

Re: Getting CMIS connection performance issue

andy — Wed, 01 Aug 2012 19:12:27 GMT

Hi

This is not expected.
Tomcat should be fine.
Is it the same with 4.0.d?

What are you using for authentication?
What client are you using?
Is this CPU bound?

Andy

Re: Getting CMIS connection performance issue

eleman304 — Mon, 06 Aug 2012 12:01:07 GMT

Hi Andy,

Is it the same with 4.0.d?

I cant try with 4.0d because i have 3M documents only LIVE env. and i cant upgrade to 4.0d now

What are you using for authentication?

Basic authentication. All connection use same user

What client are you using

Open Cmis with swing env.

Is this CPU bound?

Yes.

Indeed as i understood problem occur because of audit logs and each time i get cmis connection following sql execute twice and return 27M records

select
            app.app_name_id             as audit_app_name_id,
            entry.id                    as audit_entry_id,
            entry.audit_user_id         as audit_user_id,
            entry.audit_time            as audit_time,
            entry.audit_values_id       as audit_values_id
        from
            alf_audit_app app
            join alf_audit_entry entry on (entry.audit_app_id = app.id)
            
         
        
         
         WHERE app.app_name_id = 3 
     
         
         
         
        order by
            entry.id desc;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

i come through the problem by ;
- change app_name_id in alf_audit_app table for my default user (All client authenticate to alfresco with same user )
- disable audit log