- This topic has 4 replies, 3 voices, and was last updated 19 years, 3 months ago by
.
-
Posts
-
I’m using
MyEclipse4 Final with Eclipse 3.1 on Tomcat 5.0.28
Hibernate 2
Oracle 9iR2 (which has no perfomance problems!!!)The Database contains about 50 Tables, and my Application needs about 10 of them. After linking one table with the Database-Explorer, Hibernate needs all tables related to this one and so on…. So in fact, it would be necessarry to map all tables to hibernate.
However, I wont do that (because it is nonsense), and edited some XXX.hbm.xml files to get it work.Now my problem – It takes a very very long time to fetch some rows with a Hibernate query (but it is working). For example, a “return query.list” where query is a Statement which should return all rows of a table containing 4 rows takes about 5 minutes!
Anyone an idea whats going wrong? Is my problem related to the deletion of some mappings in the hbm.xml-files?
greetings Martin
It may be that your program is pulling in child records for that table also. Are you querying for a top level table which is refered to by other entries?
Moving to OT > Soft Dev, Hibernate performance is one of the biggest topics in the Hibernate forums, these guys can usually help with suggestions and I would tend to agree with ttrostel, most Hibernate issues are due to you pulling more records than you actually think you are pulling.
@ttrostel wrote:
It may be that your program is pulling in child records for that table also. Are you querying for a top level table which is refered to by other entries?
thx for answering!
my table design
HelpTable
——-
Helptable_id
descriptionTable
———-
ID
Helptable_id
….
….I would like to fetch all records of HelpTable, which has a foreign key referenced from table to the helptable_id.
The table named “table” references to many other tables…I think you are right, that hibernate fetches data I do not need. How can I control that? Any suggestions?
greetings Martin
