syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guido Wimmel (JIRA)" <>
Subject [jira] [Created] (SYNCOPE-408) Add index on task.executed
Date Thu, 01 Aug 2013 10:23:49 GMT
Guido Wimmel created SYNCOPE-408:

             Summary: Add index on task.executed
                 Key: SYNCOPE-408
             Project: Syncope
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.1.3
            Reporter: Guido Wimmel
            Priority: Minor
         Attachments: indexes.xml.patch

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() performs a full
scan on all entries of the task table with DTYPE="NotificationTask" (which could be a large
number as all executed tasks are kept), although only very few tasks are selected (those with

Creating an index on task.executed solved this problem; attached is a corresponding patch
against the branch 1.1.X.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message