issue « Performance « JPA Q&A





1. Performance Issue in Hibernate?    coderanch.com

Hi i am facing very strange behavior in hibernate which is described below I have written a function which fetch one city of a particular state the hbm mapping of files are given below: city.hbm city_sequence State.hbm

3. Performance issue for SessionImpl.get    forum.hibernate.org

Hi all, I am facing a J2EE application problem when using hibernate. Here are my program version. hibernate3.2.5 WAS6.1.0.23 spring2.0.6 Java1.5 We experience long response time for the SessonImpl.get method at random time and random server. We have seen it several times and eliminate the problem from DB/network, as only some of the servers (in random) having the same functions experience ...

4. Performance issues on Edit page    forum.hibernate.org

I have 5 levels hierarchy tables with OneToMany relationship constraints for example: (Country, City, School, Class and Student) I create a search page for the lowest level (student) in the hierarchy with full CRUD choice which works fine. My problem is on the Update, Create (Edit Page) for each student On the UI I create a Select Box that holds the ...

5. performance issue    forum.hibernate.org

Hibernate performance In one hibenate project We are having performance issue Like if in one screen we have to highlight the car booked times per day am/pm wise for 3 months For each booking we are updating one row in db like today from 10 am to 11 pm like. So in screen am or pm section gets color highlight .like ...

6. FetchMode.SUBSELECT + performance issue    forum.hibernate.org

Dear all, I just made a 1-n relation between entities Contrat and Mouvement put in work, in a context of pagination. HQL Request code: Code: String lQueryString = "SELECT c FROM Contrat c JOIN FETCH c.client client WHERE c.client.id = :clientId ORDER BY c ASC"; ...

7. Performance Issues with JPA IN Clause    forum.hibernate.org

I am using Hibernate to power a JPA query with an IN clause. Looking at the logging, I would say that Hibernate is executing a SELECT statement for each item in the IN clause. The number of items in the IN could be as many as 1000, so this could mean 1000 individual SELECT statements. Performance is an issue for my ...

8. performance issue in one-to-many    forum.hibernate.org

9. New to Hibernate - Performance Issues    forum.hibernate.org

Hi All I'm new to Hibernate. It would be great if someone can guide me in the right way. My issue is: I'm saving about 100 records (maximum is 1000) from the CSV to the DB. The CSV has 7 columns. One of the columns is "PracticeId". Before saving to the DB, I must retrieve 2 more values from a different ...





10. Hibernate performance issue    forum.hibernate.org

I am developing a web application using JSF and hibernate to connect to oracle. my "current_session_context_class" property is "thread". When user send request to server, my application use getCurrentSession to retrieve a session, and commit before response to request. When I use oracle sqlplus to query "Select * From v$session", why it only show one session created by hibernate? If may ...

11. Performance Issues    forum.hibernate.org

Hello that such: I have the following case, I do a query to the table1 and gives me 41 data stored in a List1 Iterate list1 to make another query to table2 and 23 994 data stored in a List2 Iterate list2 and for each record that meets certain conditions you do your Session.save I can not have a single query ...

12. hibernate performance issues    forum.hibernate.org

The default PermGen space is between 64m and 80m depending on your system architecture, and if your application loads many classes it easily may be to small. I suggest yoy to increase the PermGen space by specifying vmOption -XX:MaxPermSize=128m If 'OutOfMemoryError: PermGen space' still appears even with higher values, then as next step I suggest to analyze the PermGen space i.e. ...

13. Performance issue with Hibernate upgraded to 3.6.4.Final    forum.hibernate.org

Hi, I don't think HHH-5790 should have such an effect, unless you're massively hit by it in a very specific use case. Anyway, issue is solved now. There is no known performance problem, especially comparing to 3.2.x there should be only many improvements. I'd suggest to enable logging on the connection pool and verify that you don't have unclosed sessions / ...

14. Hibernate performance issue    forum.hibernate.org

I have a jsp which has to display result of 35 queries in tabular form. The table consists of 3 colomns. All these 35 queries are written in hibernate using createSQLQuery(). Result of each query is a single record. I am directly calling the DAO class that executes these 35 queries in jsp. The jsp is taking lot of time to ...

15. setParameter() and setParameterList() performance issues?    forum.hibernate.org

Hi, We are using native SQL with Hibernate 3.5.6 and when we use setParameter() and setParameterList() with DB2, our queries are 50+ seconds vs. 5-6 seconds if we do string replacement of values directly from the SQL string. I am trying to determine if it is a Hibernate or DB2 issue. Can you please advise the best way to determine what's ...

16. Performance issues on Hibernate    forum.hibernate.org

Hi, i know that hibernate (and other o/r mappers) uses methodologies and techniques like lazy instanciation, inteligente update, etc... This way, is not trivial to measure performace by methods, and the correct way should be by a use case (should give a "real" value). Anyway, i tried something home wich actually surprised me. I'm measuring the time a method takes to ...





18. performance issue    forum.hibernate.org

Hi all, I am currently experiencing some strange performance issues with (I think) Hibernate version 2.1.6 with JBoss 4.0 on Fedora Core Linux 2 on a machine with 2gb ram, mySQL 4.1. It is running as a HAR in JBoss. The following query runs in mySQL in 0.01ms: Code: mysql> select * from workflow_project where DATE_SUB( CURDATE(),INTERVAL 5 DAY ) <= ...

19. performance issue...    forum.hibernate.org

Hi, I had a simple query like "from Person" to get all people. Person has a many-to-many relationship with Category, and it has a set of the categories it is belong to. There is no other relationship of Person. So database is simply a person, category person_category tables. Performing such query with hibernate takes a very long time (3x or 4x ...

20. Performance Issue    forum.hibernate.org

Hibernate version:Hibernate 2.1 Name and version of the database you are using:MySQL 4.0.12 Testing Machine: Intel P4 2.8G, with 1G RAM, running WindowsXP I'm testing and tunning the performance of the Hibernate Layer and the database in my application. I have an object in class A, with childrens and sub-childrens. In total, the no. of all objects / sub-objects under an ...

21. Performance issues using query.scroll()    forum.hibernate.org

[b]Summary: Query.scroll() returning ScrollableResults is very slow. [/b] [b]Hibernate version: 2.1.6[/b] [b]Mapping documents:[/b] [code][/code] [b]Name and version of ...

22. Performance issues    forum.hibernate.org

23. Migrating 2.1 to 3.0 performance issues    forum.hibernate.org

Beginner Joined: Mon Dec 06, 2004 4:20 pm Posts: 34 In migrating from 2.1 to 3.0, I am finding significant performance problems when the session factory digests the mapping files. I have about 150 mapping files that were converted from 2.1 to 3.0 (via xdoclet regeneration). My performance has since suffered greatly. When the SessionFactory loads the mappings it now takes ...

24. Performance Issues on Reflection and Cross-Reference on VO    forum.hibernate.org

In this example whe have an onte-to-many relationship from item to title Advisers have given me two ways to do it: Query example. Load an item with x code, showing title and item data on page. 1- Referencies and documentation found on Hibernate Hibernate Forum / Hibernate Reference / Hibernate in Action and how i using it To load an item ...

25. Performance issue running query in hibernate    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.0.5 [b]Mapping documents: AccountSummary class maps to view account_summary account_serial

26. Help: Hibernate 2.1.7 performance issue    forum.hibernate.org

I run into a strange Hibernate performance issue these days. Hopefully someone can give me some advice. I defined two class mappings and use the following code to load them from database: hsql = "select r,c from " + RepActivityRuntime.class.getName() + " r," + RepActExecTimeConfig.class.getName() + " c " + "where r.flowId in (:flowids) and c.id=r.id and r.state not in (:states)"; ...

27. many-to-one relationship performance issues    forum.hibernate.org

I needed to map a many-to-one association to a table but it needs to map on two different columns neither of which are the primary key, and one of the values must be specified manually. So this is what i came up with: Code: '00002' which ...

28. Performance issue with Hibernate    forum.hibernate.org

Hibernate version: 3.2.5 Developed application in Hibernate. Hibernate made life simpler to connect and retrieve the data as objects. About the problem We have three environments dev/testing/production While developing the application tested the hibernate performance with 50000 records and it was working fine. When we moved to testing environment, there are around 20 million records in the database, to execute a ...

29. The Hibernate performance issues    forum.hibernate.org

30. Performance issues    forum.hibernate.org

Hi, I am facing major issues related to hibernate performance. So while trying to optimize my application i came across following queries and doubts. Can anybody plz help: (a) While reading whole graph of objects from database, i thought using setReadOnly on 'Session' object or 'StatlessSession' should benefit but it seems they work only on single object and not on graphs. ...

31. Ensuring no performance-related issues are there    forum.hibernate.org

Hi every one. This is my Table structure... Tbl_Products Product_id (primary key) Product_name Subcategory_name And Tbl_Car Product_id (primary key) Fuel_Type Horse_Power And Tbl_Tv Product_id (primary key) No_Of_Channels Tv_Type I need to provide a relationship between these tables. Hence I use the OneToOne relation between the product table and all other subcategory tables. Following is my table entity bean classes. Code: @Entity ...

32. Ensuring no performance-related issues are there    forum.hibernate.org

Hi every one. This is my Table structure... Tbl_Products Product_id (primary key) Product_name Subcategory_name And Tbl_Car Product_id (primary key) Fuel_Type Horse_Power And Tbl_Tv Product_id (primary key) No_Of_Channels Tv_Type I need to provide a relationship between these tables. Hence I use the OneToOne relation between the product table and all other subcategory tables. Following is my table entity bean classes. Code: @Entity ...

33. Finder Performance Issues    forum.hibernate.org

Hibernate version: 2.1 Code between sessionFactory.openSession() and session.close(): Code: List records = session.find( "from BalanceVO as balance" + ...

34. Performance Issues    forum.hibernate.org

Hibernate version: hibernate 3 Name and version of the database we are using: Oracle 10g This is first time we are developing a J2EE application using Hibernate. We detected performance problems with queries including several tables and joins. We normally use annotations or HQL statements. Those queries done manually in SQL take time from milliseconds to 2 seconds. But if we ...

35. Performance issues    forum.hibernate.org

Hi, Hibernate version: 3.2.5.ga Mysql 5 I'm having some performance issues with hibernate. My project is based on appfuse-light with struts2-spring-hibernate. I have an import file called import.xml that among other things contains data of regions from which you can see below. There are about 16000 of these elements. When starting the import it goes really fast. After a few seconds ...

36. Performance Issue    forum.hibernate.org