I have WebAppA using H2 in-memory database.
When WebAppA is deployed alone I get query times of about 300ms for 2k entities.
When WebAppA is deployed with WebAppB (HSQL file database) query times take 3x longer (1000 ms for 2k entities).
This occurs without any interaction with WebAppB. I also tried stripping WebAppB from any DataSource persistence but get the same results.
Any ideas on why the performance hit? Is there extra configuration that can address this?
WebAppB contained a log4j.properties file that was setting org.hibernate logging to DEBUG. Our system also set a logging level so it wasn't obvious.
Setting WebAppB logging to appropriate levels fixed the issue.
Retrieving data ...