Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGFjMjI1MjQw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) HHH-16410 ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) SingleIdEntityLoader repeatedly translates SQL AST ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For byId lookups, it looks like {{org.hibernate.loader.ast.internal.SingleIdEntityLoaderDynamicBatch#load}} is called, and that causes SQL translation over and over again, though it should be cached. It is also looks fishy to me that we do not try to cache SQL statements for a certain batch size, though that isn’t important for now. In a throughput test, this was identified as causing perf issues compared to 5. ( https://hibernate.atlassian.net/browse/HHH-16410#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16410#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:57c27f3 )