[jira] [Commented] (OOZIE-1803) Improvement in Purge service

["Jaydeep Vishwakarma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OOZIE-1803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13976489#comment-13976489 ] 

Jaydeep Vishwakarma commented on OOZIE-1803:
--------------------------------------------

Following areas where we can work on to improve the performance
1. Need index on end_time
2. Need index on foreign key
3. Many places we have multiple and repeated queries to select the eligible rows to remove which can be fetched by single call.
4. Bulk remove with default 1k limit.

> Improvement in Purge service
> ----------------------------
>
>                 Key: OOZIE-1803
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1803
>             Project: Oozie
>          Issue Type: Improvement
>          Components: core
>            Reporter: Jaydeep Vishwakarma
>
> Current purge service of oozie have some performance issues and it might help to look at the queries and indexes to improve the the purge service.



--
This message was sent by Atlassian JIRA
(v6.2#6252)