You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jo...@apache.org on 2007/03/27 19:44:12 UTC
svn commit: r523013 - in /ofbiz/trunk/applications:
content/entitydef/entitymodel.xml order/entitydef/entitymodel.xml
product/entitydef/entitymodel.xml
Author: jonesde
Date: Tue Mar 27 10:44:11 2007
New Revision: 523013
URL: http://svn.apache.org/viewvc?view=rev&rev=523013
Log:
Added a bunch of index definitions based on being annoyed by console log messages about slow queries
Modified:
ofbiz/trunk/applications/content/entitydef/entitymodel.xml
ofbiz/trunk/applications/order/entitydef/entitymodel.xml
ofbiz/trunk/applications/product/entitydef/entitymodel.xml
Modified: ofbiz/trunk/applications/content/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/entitydef/entitymodel.xml?view=diff&rev=523013&r1=523012&r2=523013
==============================================================================
--- ofbiz/trunk/applications/content/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/content/entitydef/entitymodel.xml Tue Mar 27 10:44:11 2007
@@ -351,6 +351,11 @@
<relation type="one" fk-name="CONTENTASSC_DTSRC" rel-entity-name="DataSource">
<key-map field-name="dataSourceId"/>
</relation>
+ <index name="CONTENTASSC_TOQRY">
+ <index-field name="contentIdTo"/>
+ <index-field name="contentAssocTypeId"/>
+ <index-field name="thruDate"/>
+ </index>
</entity>
<view-entity entity-name="ContentAssocDataResourceViewFrom"
package-name="org.ofbiz.content.content"
Modified: ofbiz/trunk/applications/order/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/entitydef/entitymodel.xml?view=diff&rev=523013&r1=523012&r2=523013
==============================================================================
--- ofbiz/trunk/applications/order/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/order/entitydef/entitymodel.xml Tue Mar 27 10:44:11 2007
@@ -2300,7 +2300,11 @@
<relation type="many" fk-name="RTN_ITEM_OISGIR" rel-entity-name="OrderItemShipGrpInvRes">
<key-map field-name="orderId"/>
<key-map field-name="orderItemSeqId"/>
- </relation>
+ </relation>
+ <index name="RTN_ITM_BYORDITM">
+ <index-field name="orderId"/>
+ <index-field name="orderItemSeqId"/>
+ </index>
</entity>
<entity entity-name="ReturnItemResponse"
package-name="org.ofbiz.order.return"
Modified: ofbiz/trunk/applications/product/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitymodel.xml?view=diff&rev=523013&r1=523012&r2=523013
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitymodel.xml Tue Mar 27 10:44:11 2007
@@ -253,8 +253,8 @@
<field name="purchaseThruDate" type="date-time"></field>
<field name="useCountLimit" type="numeric"></field>
<field name="useDaysLimit" type="floating-point"></field>
- <prim-key field="contentId"/>
<prim-key field="productCategoryId"/>
+ <prim-key field="contentId"/>
<prim-key field="prodCatContentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDCAT_CNT_PRDCAT" rel-entity-name="ProductCategory">
@@ -266,6 +266,10 @@
<relation type="one" fk-name="PRDCAT_CNT_TYPE" rel-entity-name="ProductCategoryContentType">
<key-map field-name="prodCatContentTypeId"/>
</relation>
+ <index name="PRDCAT_CNT_CTTP">
+ <index-field name="productCategoryId"/>
+ <index-field name="prodCatContentTypeId"/>
+ </index>
</entity>
<view-entity entity-name="ProductCategoryContentAndInfo"
package-name="org.ofbiz.product.category"
@@ -355,6 +359,9 @@
<relation type="one" fk-name="PROD_CMBR_CATEGORY" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
+ <index name="PRD_CMBR_PCT">
+ <index-field name="productCategoryId"/>
+ </index>
</entity>
<view-entity entity-name="ProductCategoryMemberAndRole"
package-name="org.ofbiz.product.category"
@@ -1604,6 +1611,12 @@
<relation type="one" fk-name="PROD_PRICE_LMBUL" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
+ <index name="PRD_PRC_GENLKP">
+ <index-field name="productId"/>
+ <index-field name="productPricePurposeId"/>
+ <index-field name="currencyUomId"/>
+ <index-field name="productStoreGroupId"/>
+ </index>
</entity>
<entity entity-name="ProductPriceAction"
package-name="org.ofbiz.product.price"