Try to see the SQL output (hibernate config option) and check where it is slow.
The query should be fast since it is only one DB table...perhaps you'll need to create
some indices
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4178304#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...