details: https://code.openbravo.com/erp/devel/pi/rev/38f553ae97a3 changeset: 16056:38f553ae97a3 user: Egoitz Castillo <egoitz.castillo <at> openbravo.com> date: Thu Apr 12 10:21:28 2012 +0200 summary: Fixed Issue 20247. Performance problem loading invoice window with 600k partners
details: https://code.openbravo.com/erp/devel/pi/rev/5b2bcd4832a0 changeset: 16057:5b2bcd4832a0 user: Egoitz Castillo <egoitz.castillo <at> openbravo.com> date: Thu Apr 12 10:37:06 2012 +0200 summary: Fixed Issue 20248. Performance problem with alerts on alerts for module diffstat: src-db/database/model/tables/AD_USER.xml | 3 +++ src-db/database/model/tables/C_BPARTNER.xml | 4 ++++ src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml | 6 ++++++ 3 files changed, 13 insertions(+), 0 deletions(-) diffs (43 lines): diff -r 115045b5d15c -r 5b2bcd4832a0 src-db/database/model/tables/AD_USER.xml --- a/src-db/database/model/tables/AD_USER.xml Wed Apr 11 19:32:51 2012 +0000 +++ b/src-db/database/model/tables/AD_USER.xml Thu Apr 12 10:37:06 2012 +0200 @@ -192,6 +192,9 @@ <index-column name="AD_CLIENT_ID"/> <index-column name="NAME"/> </index> + <index name="AD_USER_PARTNER" unique="false"> + <index-column name="C_BPARTNER_ID"/> + </index> <unique name="AD_USER_UN_USERNAME"> <unique-column name="USERNAME"/> </unique> diff -r 115045b5d15c -r 5b2bcd4832a0 src-db/database/model/tables/C_BPARTNER.xml --- a/src-db/database/model/tables/C_BPARTNER.xml Wed Apr 11 19:32:51 2012 +0000 +++ b/src-db/database/model/tables/C_BPARTNER.xml Thu Apr 12 10:37:06 2012 +0200 @@ -397,6 +397,10 @@ <foreign-key foreignTable="C_SALARY_CATEGORY" name="C_SALARY_CATEGORY_CBPARTNER"> <reference local="C_SALARY_CATEGORY_ID" foreign="C_SALARY_CATEGORY_ID"/> </foreign-key> + <index name="C_BPARTNER_IDSALESREP" unique="false"> + <index-column name="C_BPARTNER_ID"/> + <index-column name="ISSALESREP"/> + </index> <index name="C_BPARTNER_NAME" unique="false"> <index-column name="NAME"/> </index> diff -r 115045b5d15c -r 5b2bcd4832a0 src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml --- a/src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml Wed Apr 11 19:32:51 2012 +0000 +++ b/src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml Thu Apr 12 10:37:06 2012 +0200 @@ -114,6 +114,12 @@ <foreign-key foreignTable="M_PRODUCT" name="FIN_SCHEDULEDETAIL_M_PRODUCT"> <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/> </foreign-key> + <index name="FIN_PAY_SCHEDULEDETAIL_IN" unique="false"> + <index-column name="FIN_PAYMENT_SCHEDULE_INVOICE"/> + </index> + <index name="FIN_PAY_SCHEDULEDETAIL_OR" unique="false"> + <index-column name="FIN_PAYMENT_SCHEDULE_ORDER"/> + </index> <check name="FIN_PAY_SCHE_DETAIL_ISCANC_CHK"><![CDATA[ISCANCELED IN ('Y', 'N')]]></check> </table> </database> ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
