[jboss-jira] [JBoss JIRA] (DROOLS-4919) Long running query at kie-server startup

[Jonathan Fisher (Jira)]

    [ https://issues.redhat.com/browse/DROOLS-4919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13962371#comment-13962371 ] 

Jonathan Fisher commented on DROOLS-4919:
-----------------------------------------

Still hoping for an answer on this. We have to stagger our kie-server startups because a huge amount of data is being read off that table.

Thank you,
-Jonathan


> Long running query at kie-server startup
> ----------------------------------------
>
>                 Key: DROOLS-4919
>                 URL: https://issues.redhat.com/browse/DROOLS-4919
>             Project: Drools
>          Issue Type: Bug
>          Components: kie server
>    Affects Versions: 7.28.0.Final
>            Reporter: Danny Rucker
>            Assignee: Maciej Swiderski
>            Priority: Major
>
> The following query is executed at start up of kie-server
> ```
> select vil.processInstanceId, vil.processId, vil.id, vil.variableId, vil.value from VariableInstanceLog vil where vil.id in (select MAX(v.id) from VariableInstanceLog v group by v.variableId, v.processInstanceId)
> ```
> This is causing some issues with getting kie-server to start up.  



--
This message was sent by Atlassian Jira
(v7.13.8#713008)