[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3291) Hibernate QueryStatistics should permit keying by Named Query nickname when available
Jim Doyle (JIRA)
noreply at atlassian.com
Mon May 19 14:48:33 EDT 2008
Hibernate QueryStatistics should permit keying by Named Query nickname when available
-------------------------------------------------------------------------------------
Key: HHH-3291
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3291
Project: Hibernate3
Issue Type: Improvement
Affects Versions: 3.2.x
Environment: JBoss 4.2.2
Reporter: Jim Doyle
This request is related to the additional feature request HHH3289 for show_sql.
QueryStatistics are keyed by the full HQL query string. For monitoring and tuning persistence tier performance in midsize to large applications, it is more
convenient to store the Named Query name rather than the full HQL such that the application developers can locate the named query in their annotated
core, or in orm.xml, and make the changes needed to conduct performance tuning.
I propose changing the mechanism that deposits query statistics:
use the Query Name for Named JPQL/HQL and Named Native Queries
prefix ad hoc native SQL queries with 'native;" and use that as the statistics key
use the existing HQL query string for all ad hoc HQL queries
--
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
More information about the hibernate-issues
mailing list