Hi all,
i have following problem:
I have an entity name AspectDependentTest with following mapping file:
<mapping>
<key-generator name="SEQUENCE" alias="RETURNING_AspektDep">
<param name="sequence" value="AspektTest_SEQ"/>
<param name="returning" value="true"/>
</key-generator>
<class name="com.siemens.cds9.jdo.AspectDependentTest" identity="aspectId"
key-generator="RETURNING_AspektDep">
<map-to table="Aspect_Dep_Test" />
<field name="aspectId" type="java.lang.Integer">
<sql name="AspectId" type="integer" dirty="ignore" />
</field>
<field name="position" type="java.lang.Integer">
<sql name="Position" type="integer" dirty="ignore" />
</field>
<field name="AspectName"
type="com.siemens.cds9.jdo.AspectNameDependentTest" collection="arraylist">
<sql many-key="AspectId" />
</field>
</class>
</mapping>
It has a one to many relationship denoted by field AspectName.
The mapping file for AspectNameDependentTest is as follows:
<mapping>
<key-generator name="SEQUENCE" alias="RETURNING_Aspekt_NameDep">
<param name="sequence" value="Aspekt_Name_Test_SEQ"/>
<param name="returning" value="true"/>
</key-generator>
<class name="com.siemens.cds9.jdo.AspectNameDependentTest" identity="id"
depends="com.siemens.cds9.jdo.AspectDependentTest5555"
key-generator="RETURNING_Aspekt_NameDep">
<map-to table="Aspekt_Name_Dep_Test" />
<field name="id" type="java.lang.Integer">
<sql name="id" type="integer" dirty="ignore" />
</field>
<field name="Language" type="java.lang.String">
<sql name="Language"/>
</field>
<field name="Name" type="java.lang.String">
<sql name="Name" type="varchar" dirty="ignore" />
</field>
<field name="aspect" type="com.siemens.cds9.jdo.AspectDependentTest">
<sql name="aspectid" />
</field>
</class>
</mapping>
Herein there is a backward reference to AspectDependentTest denoted by field aspect.
First of all the performance for a select on AspectDependentTest is a problem now.
For 500 rows in the table Aspect_Dep_Test and 1500 rows in the table
Aspekt_Name_Dep_Test
a read over all rows costs 7 s.
If i remove the backward reference object with an integer as an id, then the same
select on
the same data volume will cost about 0.9 s (Notice: in this case i'm doing another
query and iteration
on Aspect_Name_Dep_Test to really read the data).
thx in advance,
Mark Baier
Softwareentwicklung
SOLYP Informatik GmbH
Frommannstr. 17
D-90419 N�rnberg
Germany
Fon: +49-911-93334-5
Fax: +49-911-93334-88
mailto:[EMAIL PROTECTED]
+++ NEWS +++ NEWS +++ NEWS +++ NEWS +++ NEWS
Siemens plant mit Solyp. Konzernweites Planungs-Tool der Siemens AG, "Strategy and
Goals Information System" (SGI) basiert auf Framework-L�sung MCMS
http://www.solyp.de/3161.html
+++ +++ +++ +++ +++ +++ +++ +++ +++ +++ +++ +++
SQL Developer - das universell einsetzbare Frontend f�r Datenbank-Entwickler
http://www.pressetext.at/pte.mc?pte=020828004
Solutions for your profit
http://www.solyp.de
SQL Developer - das universell einsetzbare Frontend f�r Datenbank-Entwickler
http://www.pressetext.at/pte.mc?pte=020828004
Solutions for your profit
http://www.solyp.de
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
