[activemq-artemis] branch master updated: ARTEMIS-2465 [JDBC-STORE] Adding index on txId

[cl...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

clebertsuconic pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/activemq-artemis.git


The following commit(s) were added to refs/heads/master by this push:
     new fb01bc5  ARTEMIS-2465 [JDBC-STORE] Adding index on txId
     new 298ad01  This closes #2814
fb01bc5 is described below

commit fb01bc5644405d61b9eaa70d34688bfdddca24b6
Author: Francesco Nigro <ni...@gmail.com>
AuthorDate: Wed Aug 28 16:45:41 2019 +0200

    ARTEMIS-2465 [JDBC-STORE] Adding index on txId
---
 .../org/apache/activemq/artemis/jdbc/store/sql/PropertySQLProvider.java  | 1 +
 artemis-jdbc-store/src/main/resources/journal-sql.properties             | 1 +
 2 files changed, 2 insertions(+)

diff --git a/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/sql/PropertySQLProvider.java b/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/sql/PropertySQLProvider.java
index 2f29cf9..118725a 100644
--- a/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/sql/PropertySQLProvider.java
+++ b/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/sql/PropertySQLProvider.java
@@ -87,6 +87,7 @@ public class PropertySQLProvider implements SQLProvider {
       return new String[] {
               format(sql("create-journal-table"), tableName),
               format(sql("create-journal-index"), tableName),
+              format(sql("create-journal-tx-index"), tableName)
       };
    }
 
diff --git a/artemis-jdbc-store/src/main/resources/journal-sql.properties b/artemis-jdbc-store/src/main/resources/journal-sql.properties
index 1ac4bff..a9a7aba 100644
--- a/artemis-jdbc-store/src/main/resources/journal-sql.properties
+++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties
@@ -30,6 +30,7 @@ copy-file-record-by-id=UPDATE %1$s SET DATA = (SELECT DATA FROM %1$s WHERE ID=?)
 drop-table=DROP TABLE %s
 create-journal-table=CREATE TABLE %s(id BIGINT,recordType SMALLINT,compactCount SMALLINT,txId BIGINT,userRecordType SMALLINT,variableSize INTEGER,record BLOB,txDataSize INTEGER,txData BLOB,txCheckNoRecords INTEGER,seq BIGINT NOT NULL, PRIMARY KEY(seq))
 create-journal-index=CREATE INDEX %1$s_IDX ON %1$s (id)
+create-journal-tx-index=CREATE INDEX %1$s_TX_IDX ON %1$s (txId)
 insert-journal-record=INSERT INTO %s(id,recordType,compactCount,txId,userRecordType,variableSize,record,txDataSize,txData,txCheckNoRecords,seq) VALUES (?,?,?,?,?,?,?,?,?,?,?)
 select-journal-record=SELECT id,recordType,compactCount,txId,userRecordType,variableSize,record,txDataSize,txData,txCheckNoRecords,seq FROM %s ORDER BY seq ASC
 delete-journal-record=DELETE FROM %s WHERE id = ?