I am running into a huge performance issue and was hoping to get some
guidance on where to start looking for a problem. Then mapping portion
causing the problem deals with employees for a company. I currently have
this modeled as a bi-directional 1:n mapping (Company has a collection of
employees and Employee has a reference to its Company). Both sides of the
association are set to be proxies (collection-proxy and reference-proxy).
I then tested by loading 2 companies, one with 175 employees and another
with 1524 (the results were pretty much the same querying the Employee
object by its company). Accessing the employee collection on the first
company took 1.5 secs to load. Accessing the employee collection on the
second took 2 minutes and 5 secs to load.
Thats not even close to linear, so I am thinking I must be doing something
wrong. Any help troubleshooting this would be greatly appreciated. Below
are the mappings for both classes. I am using the
PersistentFieldMaxPerformanceImpl for the PersistenceFieldClass and a JNDI
Datasource.
<!--
############################################################################
###
## Company entity type mapping
############################################################################
###
-->
<class-descriptor
class="com.vignette.it.apps.server.domain.entities.Company"
table="COMPANY"
>
<field-descriptor
name="id"
column="COMP_ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor
name="parentId"
column="PRNT_COMP_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="pending"
column="PENDING_APPRVL_FLG"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldCo
nversion"
/>
<field-descriptor
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="aliases"
column="ALIASES"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="numberOfVignetteSites"
column="NUM_OF_VIGN_SITES"
jdbc-type="INTEGER"
/>
<field-descriptor
name="annualRevenueAmount"
column="ANNUAL_REV"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="annualRevenueCurrencyId"
column="ANNUAL_REV_CURR_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="potentialOpportunityAmount"
column="POTNL_OPP"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="potentialOpportunityCurrencyId"
column="POTNL_OPP_CURR_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="fortuneListId"
column="FORT_LIST_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="geographyId"
column="GEO_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="customerStatusId"
column="CUST_PROD_STAT_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="createdBy"
column="CRTD_BY"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="createdDate"
column="CRTD_DT"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest
ampFieldConversion"
/>
<field-descriptor
name="modifiedBy"
column="CHGD_BY"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="modifiedDate"
column="CHGD_DT"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest
ampFieldConversion"
/>
<reference-descriptor
name="parent"
class-ref="com.vignette.it.apps.server.domain.entities.Company"
proxy="true"
>
<foreignkey field-ref="parentId"/>
</reference-descriptor>
<reference-descriptor
name="annualRevenueCurrency"
class-ref="com.vignette.it.apps.server.domain.entities.Currency"
proxy="true"
>
<foreignkey field-ref="annualRevenueCurrencyId"/>
</reference-descriptor>
<reference-descriptor
name="potentialOpportunityCurrency"
class-ref="com.vignette.it.apps.server.domain.entities.Currency"
proxy="true"
>
<foreignkey field-ref="potentialOpportunityCurrencyId"/>
</reference-descriptor>
<reference-descriptor
name="fortuneList"
class-ref="com.vignette.it.apps.server.domain.entities.FortuneList"
proxy="true"
>
<foreignkey field-ref="fortuneListId"/>
</reference-descriptor>
<reference-descriptor
name="geography"
class-ref="com.vignette.it.apps.server.domain.entities.Geography"
proxy="true"
>
<foreignkey field-ref="geographyId"/>
</reference-descriptor>
<reference-descriptor
name="customerStatus"
class-ref="com.vignette.it.apps.server.domain.entities.CustomerStatus"
proxy="true"
>
<foreignkey field-ref="customerStatusId"/>
</reference-descriptor>
<collection-descriptor
name="addresses"
element-class-ref="com.vignette.it.apps.server.domain.entities.CompanyAddres
s"
orderby="hqAddress"
sort="DESC"
proxy="true"
>
<inverse-foreignkey field-ref="companyId"/>
</collection-descriptor>
<collection-descriptor
name="phones"
element-class-ref="com.vignette.it.apps.server.domain.entities.PhoneNumber"
proxy="true"
indirection-table="COMP_PHONE_NUM_JT"
>
<fk-pointing-to-this-class column="COMP_ID"/>
<fk-pointing-to-element-class column="PHONE_NUM_ID"/>
</collection-descriptor>
<collection-descriptor
name="vignRelationships"
element-class-ref="com.vignette.it.apps.server.domain.entities.CompanyRelati
onship"
proxy="true"
indirection-table="COMP_COMP_TYPE_JT"
>
<fk-pointing-to-this-class column="COMP_ID"/>
<fk-pointing-to-element-class column="COMP_TYPE_ID"/>
</collection-descriptor>
<collection-descriptor
name="industries"
element-class-ref="com.vignette.it.apps.server.domain.entities.Industry"
proxy="true"
indirection-table="COMP_IND_JT"
>
<fk-pointing-to-this-class column="COMP_ID"/>
<fk-pointing-to-element-class column="IND_ID"/>
</collection-descriptor>
<collection-descriptor
name="employees"
element-class-ref="com.vignette.it.apps.server.domain.entities.Contact"
proxy="true"
>
<inverse-foreignkey field-ref="companyId"/>
</collection-descriptor>
</class-descriptor>
<!--
############################################################################
###
## Contact entity type mapping
############################################################################
###
-->
<class-descriptor
class="com.vignette.it.apps.server.domain.entities.Contact"
table="COMP_PERS_JT"
>
<field-descriptor
name="id"
column="COMP_PERS_ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor
name="companyId"
column="COMP_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="personId"
column="PERS_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="managerId"
column="MGR_COMP_PERS_ID"
jdbc-type="INTEGER"
/>
<field-descriptor
name="title"
column="TITLE_1"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="title2"
column="TITLE_2"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="primary"
column="PRIMARY_FLG"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldCo
nversion"
/>
<field-descriptor
name="active"
column="ACTIVE_FLG"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldCo
nversion"
/>
<field-descriptor
name="createdBy"
column="CRTD_BY"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="createdDate"
column="CRTD_DT"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest
ampFieldConversion"
/>
<field-descriptor
name="modifiedBy"
column="CHGD_BY"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="modifiedDate"
column="CHGD_DT"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest
ampFieldConversion"
/>
<reference-descriptor
name="company"
class-ref="com.vignette.it.apps.server.domain.entities.Company"
proxy="false"
>
<foreignkey field-ref="companyId"/>
</reference-descriptor>
<reference-descriptor
name="person"
class-ref="com.vignette.it.apps.server.domain.entities.Person"
proxy="false"
>
<foreignkey field-ref="personId"/>
</reference-descriptor>
<reference-descriptor
name="manager"
class-ref="com.vignette.it.apps.server.domain.entities.Contact"
proxy="true"
>
<foreignkey field-ref="managerId"/>
</reference-descriptor>
<collection-descriptor
name="addresses"
element-class-ref="com.vignette.it.apps.server.domain.entities.Address"
proxy="true"
indirection-table="COMP_PERS_ADDR_JT"
>
<fk-pointing-to-this-class column="COMP_PERS_ID"/>
<fk-pointing-to-element-class column="ADDR_ID"/>
</collection-descriptor>
<collection-descriptor
name="phones"
element-class-ref="com.vignette.it.apps.server.domain.entities.PhoneNumber"
proxy="true"
indirection-table="COMP_PERS_PHONE_NUM_JT"
>
<fk-pointing-to-this-class column="COMP_PERS_ID"/>
<fk-pointing-to-element-class column="PHONE_NUM_ID"/>
</collection-descriptor>
</class-descriptor>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
