Performance issue

[anette]

Hello,

I am new in alfresco and I am currently maintaining an application which is built in alfresco CMS. 

There is a big problem with that app, it is very very slow, being unusuable because of long respnse times that it has. 

I cannot find which may be the issue on that. Can you please suggest me in finding where is the problem and how can it be fixed?

Many thanks in advanced.

[dharmendra_pan2]

Hello Aneta,

You can perform following tasks to improve the performance of your alfresco and I hope this might help you..

1. Ask your DBA to re-build indexes and build database statistics (In mysql and postgres this is quite easy).

2. Disable activities feed, I mean you can ignore alfresco activities feeds which are not required and necessary (record limited activities) like below in alfresco-global.properties file

         activities.post.ignored-types=org.alfresco.documentlibrary.file-liked,org.alfresco.documentlibrary.file-previewed

3. Do not run  alfresco activities.feed.cleaner job by default which runs every 15 minutes, this causes database performance issues due to more frequent delete of data, you can schedule it to run every night  and have the database script to reindex this table every day after delete.

activities.feed.cleaner.enabled=true
activities.feed.cleaner.cronExpression=0 0 1 * * ?

Insert in to database is never a problem but delete always takes time, indexes need to be rebuild.

4. if you have enabled alfresco audit then do not record all the event and you should customize it to record limit number of events

5. Push all the schedule job in night like ldap sync,solr index backup, custom schedule job if any and you can.

6. Configure the schedule job to delete the user's trashcan after 90 days which will deletes lots of records form database.

-D