Hi,
I use ejb3 entity as my persistence layer and i have a table in database contains more than 200,000 records. Every time i retrieve datas from this table it takes long long for results.:(( Is there a way to tune hibernate Entity Manager to let it runs faster?

Any help or advises will be appreciated!

http://www.hibernate.org/5.html
Check all docs talking about fetching and lazy loading