[jira] [Comment Edited] (ARTEMIS-852) Add indices to tables from JDBC backend to increase performance

["Benjamin Graf (JIRA)" <ji...@apache.org>]

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

Benjamin Graf edited comment on ARTEMIS-852 at 11/15/16 7:54 PM:
-----------------------------------------------------------------

Yes its plain sql. But the framework needs to execute several statements even after merging some into initial create. I will create an initial patch tomorrow morning CET.


was (Author: graben):
Yes its plain sql. But the framework needs to execute several statements even after merging some into initial create.

> Add indices to tables from JDBC backend to increase performance
> ---------------------------------------------------------------
>
>                 Key: ARTEMIS-852
>                 URL: https://issues.apache.org/jira/browse/ARTEMIS-852
>             Project: ActiveMQ Artemis
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Benjamin Graf
>            Priority: Blocker
>             Fix For: 1.6.0
>
>
> Almost every query used in Artemis uses where clauses but BINDINGS_TABLE and MESSAGE_TABLE actually have no indices. This causes performance impact.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)