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 > Tas

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 TaskDAO.findToExec(