query « Performance « JPA Q&A





1. Is it possible to review/optimize a Hibernate query plan?    stackoverflow.com

Is there some facility in Hibernate for viewing the query plan for a query? I can look at the source code and trace the joins and eager fetches and hope that ...

2. Hibernate Named Query Performance    coderanch.com

First, I admit that the question I am asking so broad and you will ask me more detail but I have no more information and I am looking for an idea. I am using hibernate named query for selecting a list from huge database, in each select I get about 15.000 object on the list. I am getting list, I am ...

3. named query performance gain?    forum.hibernate.org

Hi all, I have a quite simple question about the namedQueries in Hibernate. Lets say we use an Oracle Database, is there a performance gain if you use a name query strategy in your daos, instead of creating new (but same) query each time you hit the database and adding binded parameters to it? I didn't find any straight answer around. ...

4. Query performance    forum.hibernate.org

I'm new to hibernate, but trying to get up to speed as quickly as possible. I'm currently working through how to optimize a search query, I imagine the first implementation can run up to 30 minutes, so clearly not acceptable. I have a list of people, who have relationships to other people. From my initial query based upon user input, I ...

5. Hibernate performance query    forum.hibernate.org

6. Improving performance of a hibernate one->many query    forum.hibernate.org

Newbie Joined: Fri Sep 03, 2004 3:41 am Posts: 3 Hello, This is not so much a question about "how to get something working", since the code does work, rather Im trying to optimize it. The situation is as follows: I'm performing one query, to get a list of AnalyticResult objects. Each result object will have one or more values, which ...

7. Question about query performance.    forum.hibernate.org

Hi, I have a class RM, with the following xml: .... the classes A, B, C and D don't have any association. also I have the following query: ...

8. Performance slows down with lots of queries?    forum.hibernate.org

I'm using some code similar to that listed below for batch updating a database. Note, I know that I should be using batch updates and that's what I plan on doing. However, setting aside updates, I want to know why I'm seeing slow performance with queries. When I run the following code on a data file which has about 23,000 rows ...

9. Query performance    forum.hibernate.org

Read through the article suggested. But i am anxious to know the exact changes. Say for eg: W.r.t to STORM benchmark, what were the initial and final hbm.xml and what "parameters" were changed where and howmuch?. I would really appreciate if u could relate to the example that i have refered.. Could u please helpme.





10. Query Performance    forum.hibernate.org

11. Query Building And Performance    forum.hibernate.org

Does anyone know if the way you build your query has any effect on its performance? Example: String aCatsName = "Tom"; int aCatsAge = 2; List list = null; Query query = HibernateHelper.getSession().createQuery("select Cat from Cat where Cat.name = :catname and Cat.age > :catage"); query.setString("catname", aCatsName); query.setInteger("catage", aCatsAge); list = query.list(); --OR-- String aCatsName = "Tom"; int aCatsAge = 2; List ...

12. Classic Query Parser Performance and Compatibility    forum.hibernate.org

I am running Weblogic 9.1 and Hibernate 3.1. I have read that there is the conflict between the ANTLR supplied by Weblogic and the ANTLR used by Hibernate 3.1. I have successfully got Hibernate running on my Weblogic server by adding the ANTLR jars before the WebLogic jars in the Weblogic classpath. The other supplied "solution" is to use the classic ...

13. Named queries and performance    forum.hibernate.org

14. Nammed queries and performance    forum.hibernate.org

hi all i m trying to do one named query example but it is giving null pointer exception.i m posting my logs and hbm.please let me know what is wrong in that . Thanks for your inputs in advance. //-- calling named query here Code: public List getCountryNamedBy() { ...

15. Query on performance    forum.hibernate.org

Hi this mhendra, i have a question about Hibernate in my project i am using some hundred of tables but i need to mention in my .cfg file ok but my question is if i am using one object how the hibernate will know this particular object is belongs to that paticular file and if that checks every time then perfomance ...

16. hibernate query regarding performance    forum.hibernate.org

Hi everone, I have a samll query. I have a prent and a child class the mapping of which is mentioned below. I add a child to a parent in the following manner by using addChild function in the Parent class Code: public void addChild(Child child) { this.getChildren().add(child); ...





17. Bad performance on queries    forum.hibernate.org

Hello, In my application it may happen that users performs queries that bring back a lot of data, and the performances are really poor. Therefore i have two questions. 1/ What kind of tuning can be done to improve perfs ? 2/ Is there a way to get back results asynchronously ? In that way the user won't be blocked with ...

18. Query performance    forum.hibernate.org

Hibernate Community View topic - Query performance Login Register FAQ Search View unanswered posts | View active topics Board index Hibernate & Java Persistence Hibernate Users All times are UTC - 5 hours [ DST ] Query performance Page 1 of 1 [ 1 post ] ...

19. Performance in queries    forum.hibernate.org

Hi, We are using hibernate 3.1, For searching a data in the table we need to refer atleast three tables. Which one of the following option is best 1. Using Criteria 2. Using Outer join HQL queries 3. Using Inner Join in HQL queries Whether HQL queries minimize the performance of Hibernate or not ? Thanks in advance.