<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Performance issue in Alfresco Forum</title>
    <link>https://connect.hyland.com/t5/alfresco-forum/performance-issue/m-p/69483#M22929</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Aneta,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can perform following tasks to improve the performance of&amp;nbsp;your alfresco and I hope this might help you..&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. Ask your DBA to re-build indexes and build database statistics (In mysql and postgres this is quite easy).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;activities.post.ignored-types=org.alfresco.documentlibrary.file-liked,org.alfresco.documentlibrary.file-previewed&lt;/P&gt;&lt;P&gt;3. Do not run&amp;nbsp; alfresco&amp;nbsp;&lt;SPAN&gt;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&amp;nbsp;&amp;nbsp;and have the database&amp;nbsp;script to reindex this table every day after delete.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;activities.feed.cleaner.enabled=true&lt;BR /&gt;activities.feed.cleaner.cronExpression=0 0 1 * * ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Insert in to database is never a problem but delete always takes time, indexes need to be rebuild.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;5. Push all the schedule job in night like ldap sync,solr index backup, custom schedule job if any and you can.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;6. Configure the schedule job to delete the user's trashcan after 90 days which will deletes lots of records form database.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-D&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 19 Nov 2018 14:32:53 GMT</pubDate>
    <dc:creator>dharmendra_pan3</dc:creator>
    <dc:date>2018-11-19T14:32:53Z</dc:date>
    <item>
      <title>Performance issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/performance-issue/m-p/69482#M22928</link>
      <description>Hello,&amp;nbsp;I am new in alfresco and I am currently maintaining an application which is built in alfresco CMS.&amp;nbsp;There is a big problem with that app, it is very very slow, being unusuable because of long respnse times that it has.&amp;nbsp;I cannot find which may be the issue on that. Can you please suggest me in</description>
      <pubDate>Fri, 16 Nov 2018 15:23:32 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/performance-issue/m-p/69482#M22928</guid>
      <dc:creator>anette</dc:creator>
      <dc:date>2018-11-16T15:23:32Z</dc:date>
    </item>
    <item>
      <title>Re: Performance issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/performance-issue/m-p/69483#M22929</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Aneta,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can perform following tasks to improve the performance of&amp;nbsp;your alfresco and I hope this might help you..&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. Ask your DBA to re-build indexes and build database statistics (In mysql and postgres this is quite easy).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;activities.post.ignored-types=org.alfresco.documentlibrary.file-liked,org.alfresco.documentlibrary.file-previewed&lt;/P&gt;&lt;P&gt;3. Do not run&amp;nbsp; alfresco&amp;nbsp;&lt;SPAN&gt;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&amp;nbsp;&amp;nbsp;and have the database&amp;nbsp;script to reindex this table every day after delete.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;activities.feed.cleaner.enabled=true&lt;BR /&gt;activities.feed.cleaner.cronExpression=0 0 1 * * ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Insert in to database is never a problem but delete always takes time, indexes need to be rebuild.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;5. Push all the schedule job in night like ldap sync,solr index backup, custom schedule job if any and you can.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;6. Configure the schedule job to delete the user's trashcan after 90 days which will deletes lots of records form database.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-D&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 19 Nov 2018 14:32:53 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/performance-issue/m-p/69483#M22929</guid>
      <dc:creator>dharmendra_pan3</dc:creator>
      <dc:date>2018-11-19T14:32:53Z</dc:date>
    </item>
  </channel>
</rss>

