[hibernate-issues] [JIRA] (HHH-16410) SingleIdEntityLoader repeatedly translates SQL AST

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDVmZGQwOTUy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) HHH-16410 ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) SingleIdEntityLoader repeatedly translates SQL AST ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 31/Mar/2023 01:55 AM Priority: Major Reporter: 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. ( 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 )