Performance of purge method
---------------------------
Key: AMQ-3462
URL: https://issues.apache.org/jira/browse/AMQ-3462
Project: ActiveMQ
Issue Type: Improvement
Components: Message Store
Affects Versions: 5.4.0
Environment: Oracle 11gR2 / PostgreSQL 8.4
Reporter: Hervé Barrault
When calling the purge method, it takes a long time if you have a lot of
messages.
The "request" to delete a message takes 3 parameters but there is no dedicated
index linked to this "request".
Adding a new index seems improving the performances (in my case under oracle
duration is divided by 5 for 32k messages and it is not linear).
CREATE UNIQUE INDEX ACTIVEMQ_MSGS_FULLIDX ON ACTIVEMQ_MSGS ("MSGID_PROD",
"MSGID_SEQ", "CONTAINER");
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
