fetch « Performance « JPA Q&A





1. Strategy to fetch a subset of a collection    stackoverflow.com

I have a scenario where my application has access to a session for limited time windows, during which it must fetch data from the database into memory, and then only use ...

2. Query with JOIN FETCH performance problem    stackoverflow.com

I have problem with hibernate query performance which I can't figure out. In code snippet below I need select entities with at least one mapping and filtered mapping. I'm using FETCH ...

3. Does caching object with Fetch in JPA have any performance advantage in the long run?    stackoverflow.com

Does using fetch with jpa queries have any performance boosts in the long run? Lets say I want to read 100 objects from a DB, each of these objects have a one-to-many ...

4. outer join fetching performance    forum.hibernate.org

Hi, I don't understand why find query whith outer join fetching is very slow. mapping: X ...

5. Proxy, outer join fetching and performance    forum.hibernate.org

Hi all. Is it possible to tune usage of outer join fetching for single query. In my application I have different querying scenarios - for example, when I select big list of objects, which are then renderend on web page it would be better to not use outer join fetching of related objects because of memory requirements. On the other side, ...

6. Set, Fetch -Performance Tuning    forum.hibernate.org

Hibernate is slow when it is loading, but once it is done loading it blazes in performance. Setting lazy init true is sure better thing, if you don't want to load all the set objects until requested for. How you can test it, add the lazy tag and goto variable view in your IDE to see how Hibernate loads and unloads ...

7. Performance issue with fetching 2 aggregate collections    forum.hibernate.org

Details below: Currently I have 3 separate queries to bollock together returning an Item to a customer. The first gets the Item and is a simple get by Id query. The second gets all the Items on stock and adds that to the Item (in java code inside service method), the third gets all Items on Hand with similar sort of ...

8. fetch performance    forum.hibernate.org

Hello, all Im beggining to use Hibernate in a huge ERP system which has tables with more than 15 mi rows. Were currently evaluating Hibernate for use with this system. Our other option is use JDBC directly. The key here is the performance x simplicity of code. Using Hibernate and HQL is far more simple than JDBC and SQL directly (which ...