Detect whole query cache invalidations when executing native SQL queries

vladmihalcea / hypersistence-optimizer

Hypersistence Optimizer allows you to get the most out of JPA and Hibernate. By scanning your application configuration and mappings, Hypersistence Optimizer can tell you what changes you need to do to speed up your data access layer.

https://vladmihalcea.com/hypersistence-optimizer/

Apache License 2.0

306 stars 43 forks source link

Detect whole query cache invalidations when executing native SQL queries #188

Closed jiri-pejchal closed 1 year ago

jiri-pejchal commented 1 year ago

It would be nice if the Hypersistence Optimizer could detect whole query cache invalidations caused by native DML queries that don't specify synchronized entity/query space.

Developers often forget to add a synchronized entity to native DML queries, leading to performance degradation.

vladmihalcea commented 1 year ago

That's a wonderful idea. I shall definitely add support for it!

vladmihalcea commented 1 year ago

Fixed.