|
From: <leg...@at...> - 2003-11-09 06:27:14
|
The following comment has been added to this issue:
Author: Gavin King
Created: Sun, 9 Nov 2003 12:27 AM
Body:
fixed (finally) for load(), get() and Criteria queries .... other cases to come: HQL queries, collection initialization.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: Assigned
Priority: Major
Project: Hibernate2
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Sat, 3 May 2003 10:02 AM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-04-22 13:39:24
|
The following comment has been added to this issue:
Author: CVS Notification Service
Created: Thu, 22 Apr 2004 8:45 AM
Body:
CVS COMMIT LOG:
SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/loader AbstractEntityLoader.java,1.6.2.18,1.6.2.19 CollectionLoader.java,1.15.2.14,1.15.2.15 CriteriaLoader.java,1.8.2.25,1.8.2.26 EntityLoader.java,1.19.2.8,1.19.2.9 OneToManyLoader.java,1.18.2.16,1.18.2.17 OuterJoinLoader.java,1.25.2.30,1.25.2.31
apply fix for HB-12 to collection loaders
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12?page=comments#action_12914
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: In Progress
Priority: Minor
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Components:
core
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Thu, 22 Apr 2004 8:45 AM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-04-23 06:32:16
|
The following comment has been added to this issue:
Author: CVS Notification Service
Created: Fri, 23 Apr 2004 1:37 AM
Body:
CVS COMMIT LOG:
SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/loader AbstractEntityLoader.java,1.6.2.18.2.3,1.6.2.18.2.4 CollectionLoader.java,1.15.2.13.2.3,1.15.2.13.2.4 CriteriaLoader.java,1.8.2.20.2.8,1.8.2.20.2.9 EntityLoader.java,1.19.2.8.2.2,1.19.2.8.2.3 OneToManyLoader.java,1.18.2.15.2.3,1.18.2.15.2.4 OuterJoinLoader.java,1.25.2.29.2.5,1.25.2.29.2.6
apply fix for HB-12 to collection loaders
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12?page=comments#action_12918
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: In Progress
Priority: Minor
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Components:
core
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Fri, 23 Apr 2004 1:37 AM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-04-23 13:30:14
|
The following comment has been added to this issue:
Author: CVS Notification Service
Created: Fri, 23 Apr 2004 8:35 AM
Body:
CVS COMMIT LOG:
SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/loader AbstractEntityLoader.java,1.6.2.18.2.4,1.6.2.18.2.5 CollectionLoader.java,1.15.2.13.2.4,1.15.2.13.2.5 OneToManyLoader.java,1.18.2.15.2.4,1.18.2.15.2.5 OuterJoinLoader.java,1.25.2.29.2.7,1.25.2.29.2.8 OuterJoinableAssociation.java,1.1.2.1,1.1.2.2
more work on HB-12
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12?page=comments#action_12930
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: In Progress
Priority: Minor
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Components:
core
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Fri, 23 Apr 2004 8:35 AM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-04-23 15:09:13
|
The following comment has been added to this issue:
Author: CVS Notification Service
Created: Fri, 23 Apr 2004 10:14 AM
Body:
CVS COMMIT LOG:
SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/loader AbstractEntityLoader.java,1.6.2.19,1.6.2.20 CollectionLoader.java,1.15.2.15,1.15.2.16 CriteriaLoader.java,1.8.2.26,1.8.2.27 OneToManyLoader.java,1.18.2.17,1.18.2.18 OuterJoinLoader.java,1.25.2.31,1.25.2.32
more work on HB-12
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12?page=comments#action_12931
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: In Progress
Priority: Minor
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Components:
core
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Fri, 23 Apr 2004 10:14 AM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-04-24 04:12:09
|
The following comment has been added to this issue:
Author: Gavin King
Created: Fri, 23 Apr 2004 11:18 PM
Body:
This is currently working for everything except <one-to-one property-ref=...> associations.
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12?page=comments#action_12935
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HB-12
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-12
Summary: low performance loading with optional 1-1 association
Type: Bug
Status: In Progress
Priority: Minor
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Components:
core
Assignee: Gavin King
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:02 AM
Updated: Fri, 23 Apr 2004 11:18 PM
Description:
low performance loading with optional 1-1 association
I use Hibernate 1.2.3.
There is a problem, which causes a severe performance loss:
If you have 2 entites (A and B) with a 1-1 association,
Hibernate uses an SQL query with a join (if enabled) to
load both entites with 1 statement. Wonderful! If there
is a B for an A, everything is okay.
If there is no B for a certain A, Hibernate tries
(although the 1st statment returned no instance for B)
to load B, when you invoke the corresponding getter,
which results in an unnecessary SQL query!
If there are many entities associated, there are many
unnecessesary SQL queries and the performance suffers.
Thanks
Markus
(Original: http://sourceforge.net/tracker/index.php?func=detail&aid=686577&group_id=40712&atid=428708)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|