Turn off hibernate's second level cache and query cache by default

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: 6.2.0 CE M2
• Fix Version/s: 6.2.0 CE M2
• Component/s: Core Infrastructure, Fault Tolerance > Clustering Framework, Performance > Caching Infrastructure
• Labels: None
• Epic/Theme:
  • Platform
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/7308

hibernate's second level cache and query cache is addressing the same problem as our entity/finder cache.

Keep them both on is just a waste of memory, adding more call stack, and in cluster env causing more network traffic.

Our entity/finder cache have a much seamless integration with our persistence layer, so it is better to turn off hibernate's cache by default.

There is no good reason to turn it on, unless you are using hibernate code directly(not through persistence layer) and your code rely on hibernate's caching mechanism.