[
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)
