[hibernate-issues] [JIRA] (HHH-14070) Performance: ResultSetWrapperProxy.locateCorrespondingColumnIndexMethod() should use a cache for column methods

Joerg Schweikert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee35be... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWMwYmY1MTNi... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-14070?atlOrigin=eyJpIjoiMWMwYm... ) HHH-14070 ( https://hibernate.atlassian.net/browse/HHH-14070?atlOrigin=eyJpIjoiMWMwYm... ) Performance: ResultSetWrapperProxy.locateCorrespondingColumnIndexMethod() should use a cache for column methods ( https://hibernate.atlassian.net/browse/HHH-14070?atlOrigin=eyJpIjoiMWMwYm... ) Issue Type: Improvement Affects Versions: 4.2.20 Assignee: Unassigned Attachments: patch.zip Components: hibernate-core Created: 12/Jun/2020 04:34 AM Environment: Hibernate 4.2.20 DBMS: Oracle and SQL Server Priority: Major Reporter: Joerg Schweikert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee35be... ) Profiling our database access shows that a lot of execution time is consumed while detecting the column method via reflection multiple times in ResultSetWrapperProxy.locateCorrespondingColumnIndexMethod(). Especially if a lot of result set columns are involved. This improvement suggestion use a cache instead of detecting the column method over and over again. Find a patch for Hibernate version 4.2.20 attached. A cache class IntMethodCache is hocked into ResultSetWrapperProxy. The cache fills lazy and reduce the number of Class#getMethod calls to a minimum. The same issue tackled with HHH-12699 ( https://hibernate.atlassian.net/browse/HHH-12699 ) Closed but is only fix with 5.3.2 ( https://hibernate.atlassian.net/browse/HHH-14070#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14070#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#100128- sha1:14a4bff )