> JIRA is searchable. Look for things marked as 'query-hql' as the > component... The basic idea is to drop the collection-valued fetches. Is this where you will fetch collections in a sub-select rather than a join? Regards, Michael Barker.