[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3775) Generated SQL query size is unacceptable

Generated SQL query size is unacceptable ---------------------------------------- Key: HHH-3775 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3775 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: 3.2.6, Oracle platform Reporter: Loïc Lefèvre Priority: Critical Attachments: query_original.sql, query_without_column_aliases.sql In the attachment, there is a query generated by Hibernate. The size of the query text is 96579 bytes. This is an extreme example just to show the problem. There are 22993 bytes used for alias purpose which represents 24% of the size of the query. According to a recent audit from Oracle, it appears that this kind of query just overflow the SQL area thus degrading overall performances: library cache miss ratio: 97-99% during peak activity. Please stop column aliases generation for Oracle and use real column names *when appropriate* (count(*) may need a column alias). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira