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

[Loïc Lefèvre (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira