svn commit: r523013 - in /ofbiz/trunk/applications: content/entitydef/entitymodel.xml order/entitydef/entitymodel.xml product/entitydef/entitymodel.xml

[jonesde]

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"