Return-Path: Delivered-To: apmail-activemq-dev-archive@www.apache.org Received: (qmail 16635 invoked from network); 2 Mar 2011 16:17:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Mar 2011 16:17:01 -0000 Received: (qmail 55551 invoked by uid 500); 2 Mar 2011 16:17:00 -0000 Delivered-To: apmail-activemq-dev-archive@activemq.apache.org Received: (qmail 54985 invoked by uid 500); 2 Mar 2011 16:16:58 -0000 Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@activemq.apache.org Delivered-To: mailing list dev@activemq.apache.org Received: (qmail 54969 invoked by uid 99); 2 Mar 2011 16:16:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 16:16:57 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 16:16:56 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id DF5E44C2E2 for ; Wed, 2 Mar 2011 16:16:36 +0000 (UTC) Date: Wed, 2 Mar 2011 16:16:36 +0000 (UTC) From: "Gary Tully (JIRA)" To: dev@activemq.apache.org Message-ID: <1341693856.8064.1299082596910.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] Created: (AMQ-3196) Speed up initial message delivery for offline durable sub with keepDurableSubsActive=true and JDBC store MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Speed up initial message delivery for offline durable sub with keepDurableSubsActive=true and JDBC store -------------------------------------------------------------------------------------------------------- Key: AMQ-3196 URL: https://issues.apache.org/jira/browse/AMQ-3196 Project: ActiveMQ Issue Type: Improvement Components: Message Store Affects Versions: 5.4.2 Reporter: Gary Tully Assignee: Gary Tully Fix For: 5.5.0 Follow on from https://issues.apache.org/jira/browse/AMQ-3188 Durablesubs are kept active by default, but their cursors are stopped requiring a read of the store to determine the message backlog. With a large prioritised backlog and th JDBC store, getting the store size can be costly as it requires a full table scan. Currently there are three calls to getStoreSize, there should be only one when the sub is initially created. The implication is that on reactivation of an offline durable sub, there is a delay of an additional potentially slow jdbc call before dispatch resumes. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira