syncope-dev mailing list archives

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


Guido Wimmel updated SYNCOPE-408:

    Attachment: indexes.xml.patch
> Add index on task.executed
> --------------------------
>                 Key: SYNCOPE-408
>                 URL:
>             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 executed=0).
> 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