I looked at derby database and saw ~244,000 messages on ACTIVEMQ_MSGS table, all messages have been consumed.
Why does messages was not deleted after consume? ActiveMQ logs says: ActiveMQ Cleanup Timer]2007-09-26 09:15:56,630 DefaultJDBCAdapter:537 - Executing SQL: DELETE FROM ACTIVEMQ_MSGS WHERE ( EXPIRATION<>0 AND EXPIRATION<?) OR ID <= ( SELECT min(ACTIVEMQ_ACKS.LAST_ACKED_ID) FROM ACTIVEMQ_ACKS WHERE ACTIVEMQ_ACKS.CONTAINER=ACTIVEMQ_MSGS.CONTAINER) Is there some configuration i need do? I am using Jencks 2.0 and creating the TopicSession with AUTO_ACKNOWLEDGE mode. Att, Márcio Moraes Thanks. 2007/9/26, Márcio Moraes <[EMAIL PROTECTED]>: > > After receiving and consuming ~200,000 messages with > jdbcPersistenceAdapter and derbydb ActiveMQ get slow, very slow. > > Is jdbcPersistenceAdapter-derbydb ready to use in production environment? > > What kind of persistence you guys have using? > > Att, > > Márcio Moraes > > >
