[GitHub] [qpid-broker-j] alex-rufous commented on a change in pull request #23: QPID-8294: [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages
alex-rufous commented on a change in pull request #23: QPID-8294: [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages URL: https://github.com/apache/qpid-broker-j/pull/23#discussion_r272921369 ## File path: broker-plugins/jdbc-store/src/main/java/org/apache/qpid/server/store/jdbc/AbstractJDBCMessageStore.java ## @@ -82,6 +82,8 @@ private static final String XID_TABLE_NAME_SUFFIX = "QPID_XIDS"; private static final String XID_ACTIONS_TABLE_NAME_SUFFIX = "QPID_XID_ACTIONS"; +private static final int MAX_DELETE_BATCH_SIZE = 1000; Review comment: I agree that "qpid.jdbcstore.inClauseMaxSize" is much better name than "qpid.jdbcStoreMaxDeleteBatchSize". The variable name can be changed as well to inClauseMaxSize. This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@qpid.apache.org For additional commands, e-mail: dev-h...@qpid.apache.org
[GitHub] [qpid-broker-j] alex-rufous commented on a change in pull request #23: QPID-8294: [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages
alex-rufous commented on a change in pull request #23: QPID-8294: [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages URL: https://github.com/apache/qpid-broker-j/pull/23#discussion_r272668667 ## File path: broker-plugins/jdbc-store/src/main/java/org/apache/qpid/server/store/jdbc/AbstractJDBCMessageStore.java ## @@ -82,6 +82,8 @@ private static final String XID_TABLE_NAME_SUFFIX = "QPID_XIDS"; private static final String XID_ACTIONS_TABLE_NAME_SUFFIX = "QPID_XID_ACTIONS"; +private static final int MAX_DELETE_BATCH_SIZE = 1000; Review comment: I think it would be beneficial to set maximum delete batch size using JVM system variable in case if other RDBMS have a lower limit. Something like below `private static final int MAX_DELETE_BATCH_SIZE = Integer.getInteger("qpid.jdbcStoreMaxDeleteBatchSize",1000);` This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@qpid.apache.org For additional commands, e-mail: dev-h...@qpid.apache.org