Since it's not so slow when persistence is disabled, I think the sending part
is ok. For the later one, in my understanding, write the messages to the
database shouldn't block the sending (right?). But the problem I met is that
it will take 1 to 2 minutes for ActiveMQ to receive the next message.
James.Strachan wrote:
>
> What is the slow part - sending the JMS message or waiting for the
> message to arrive in the database? If its the latter thats because
> messages are only written to the database after the journal is
> checkpointed (every minute or so)
>
> 2008/10/10 Lin.Zhang <[EMAIL PROTECTED]>:
>>
>> Hi, we got a problem when using journal configured with JDBC, here are
>> some
>> details:
>>
>> We configured the journal with an Oracle datasource, but it is
>> *extremely*
>> slow when sending messages to ActiveMQ, about 1.5 minutes per message...,
>> and our config file looks like below:
>>
>> <persistenceAdapter>
>> <journaledJDBC dataDirectory="${activemq.base}/data"
>> dataSource="#oracle-ds"/>
>> </persistenceAdapter>
>>
>> ...
>>
>> <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
>> destroy-method="close">
>> <property name="driverClassName"
>> value="oracle.jdbc.driver.OracleDriver"/>
>> <property name="url"
>> value="jdbc:oracle:thin:@10.10.10.13:1521:D15IDB01"/>
>> <property name="username" value="user"/>
>> <property name="password" value="pass"/>
>> <property name="maxActive" value="50"/>
>> <property name="poolPreparedStatements" value="true"/>
>> </bean>
>>
>> The interesting thing is that on some database, it is not slow. And if
>> the
>> persistence is disabled, there is no performance problems. I'm really
>> confused and don't know whether it is an ActiveMQ problem or Oracle
>> configuration problem.
>>
>> If anybody has this kind of problem before or has any clue about it,
>> please
>> give me some help. Thanks a lot. I can provide more details if needed.
>> --
>> View this message in context:
>> http://www.nabble.com/ActiveMQ-persistence-extremely-slow-with-JDBC-tp19910036p19910036.html
>> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> James
> -------
> http://macstrac.blogspot.com/
>
> Open Source Integration
> http://open.iona.com
>
>
--
View this message in context:
http://www.nabble.com/ActiveMQ-persistence-extremely-slow-with-JDBC-tp19910036p19928613.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
