[QPID-8305] [Broker-J][JDBC Message Store] Performance regression when increasing the number of queues linked to a topic

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: qpid-java-broker-7.1.0
• Fix Version/s: qpid-java-broker-7.1.3
• Component/s: Broker-J
• Assignee: Alex Rudyy
• Reporter: Olivier VERMEULEN
• Created: 30/Apr/19 08:14
• Updated: 19/Feb/20 10:37
• Resolved: 08/May/19 21:55

Description

When sending a message to a topic, if this message is routed to N queues then we will do N+2 database inserts: 1 for the metadata, 1 for the content and 1 for each message/queue mapping (QPID_QUEUE_ENTRIES). The last N inserts could be batched in a single operation.

Issue Links

• links to: GitHub Pull Request #30