Add index on task.executed?

2013-07-31 Thread Guido Wimmel
Hi, in our Syncope installation (1.1.3 on Tomcat/MySQL) we observed long execution times (1s) for TaskDAO.findToExec(), which is called periodically from NotificationJob to determine which notifications should be sent. According to our analysis, this is due to the fact that

Re: Add index on task.executed?

2013-07-31 Thread Francesco Chicchiriccò
Hi, in our Syncope installation (1.1.3 on Tomcat/MySQL) we observed long execution times (1s) for TaskDAO.findToExec(), which is called periodically from NotificationJob to determine which notifications should be sent. According to our analysis, this is due to the fact that