Poor performance: kie-server-spring-boot with XA datasource

[Jivko Sabev]

Greetings,

I am using the spring boot starter (kie-server-spring-boot-starter) version 7.30 configured to use narayana transaction manager. Below is the relevant configuration from the .properties file

#data source configuration
spring.datasource.username=sa
spring.datasource.password=sa
spring.datasource.url=jdbc:h2:./target/spring-boot-jbpm
spring.datasource.driver-class-name=org.h2.Driver
spring.h2.console.enabled=true
spring.datasource.tomcat.type=org.apache.tomcat.jdbc.pool.XADataSource

#hibernate configuration
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.H2Dialect
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

#transaction manager configuration
spring.jta.narayana.transaction-manager-id=1
spring.transaction.default-timeout=3600

I am seeing poor performance where the writing to the h2 database takes a very long time. The jbpm process is stuck waiting for the db write to finish for the majority of the run time. 

Any pointers improving performance are highly appreciated.

[Alessandro Lazarotti]

H2 database is just for basic tests.

I would recommend moving to regular databases (PostgreSQL, MySQL, etc) if you would like to go through performance tests.

- Alessandro

--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/8f894cb6-2e50-442b-9c98-d24670c29d9bn%40googlegroups.com.