> Also, I forgot to mention that no you can't control the frequency of this. > Durable subscriptions need to update the store on acknowledgement because > they are persistent. Message expiration is different and this query > wouldn't be affected by this. > > If you are having performance issues I would recommend looking at something > like KahaDB as a message store which should perform much better.
+1000... Databases are not meant for messaging. a DB is meant to store data in a transactional manner. Message storages will use the DB as a transient storage, for that reason I have always reject any user request towards a JDBC storage on my old HornetQ days... Although there is an opened JIRA now for a JDBC/Database storage on Artemis. I had opened that because it's one of the gaps between ActiveMQ5 and ActiveMQ-Artemis.. (and because I have had seen users requesting it on a frequent base on my day job). So, answering sreekumar, in your shoes I would either use KahaDB orif you must use a JDBC because of environment restrictions, you will need to either research DB tuning accordingly to your transient load or hire/contact a Database Specialist (aka DBA)
