topic Re: How to decrease SQL requests in Activiti? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-decrease-sql-requests-in-activiti/m-p/164235#M117986 <HTML><HEAD></HEAD><BODY><SPAN>When the history level is set to full, yes there can be quite a number of SQL statements being executed. For every variable 2 records are written to the history tables for example. When you complete a task and you are executing a number of automatic steps afterwards, then for every activity executed there will be an entry in the history activity table. If you want to reduce the amount of SQL statements being executed, the history level should be set to none.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Tue, 26 Nov 2013 09:02:25 GMT trademak 2013-11-26T09:02:25Z How to decrease SQL requests in Activiti? https://connect.hyland.com/t5/alfresco-archive/how-to-decrease-sql-requests-in-activiti/m-p/164234#M117985 Hi there,I re-post a question related to performance optimization from an user of the Activiti plugin here from the following URL:https://groups.google.com/forum/#!topic/grails-activiti-plugin/ymkd6wl0O9sAfter configuring sql log with log4jdbc in my app, I see a lot of requests to database, and my a Sat, 23 Nov 2013 03:06:03 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-decrease-sql-requests-in-activiti/m-p/164234#M117985 limcheekin 2013-11-23T03:06:03Z Re: How to decrease SQL requests in Activiti? https://connect.hyland.com/t5/alfresco-archive/how-to-decrease-sql-requests-in-activiti/m-p/164235#M117986 <HTML><HEAD></HEAD><BODY><SPAN>When the history level is set to full, yes there can be quite a number of SQL statements being executed. For every variable 2 records are written to the history tables for example. When you complete a task and you are executing a number of automatic steps afterwards, then for every activity executed there will be an entry in the history activity table. If you want to reduce the amount of SQL statements being executed, the history level should be set to none.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Tue, 26 Nov 2013 09:02:25 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-decrease-sql-requests-in-activiti/m-p/164235#M117986 trademak 2013-11-26T09:02:25Z