Getting CMIS connection performance issue

[eleman304]

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
- linux (redhat 5.5)
- 4 CPU (40 Core)
- 3 M document in alfresco
- tomcat start parameters Xss1m -Xms4G -Xmx12G -XXermSize=512m -XX:MaxPermSize=1024m -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=3G -server

And is it recommend to change app server from tomcat to Jboss ?

Thanks for your advices.

Regards.

[andy]

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

[eleman304]

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