[OpenbravoERP-commits] devel/pi: Backed out changeset 3c096d9564b0 0022300: Long time t...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/5270d6777557
changeset: 18993:5270d6777557
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Mon Dec 10 16:39:25 2012 +0100
summary:   Backed out changeset 3c096d9564b0 0022300: Long time to unpost a 
sales invoice
where there are too many rows on fact_acct table

diffstat:

 src-db/database/model/functions/FACT_ACCT_RESET.xml |  6 ++----
 1 files changed, 2 insertions(+), 4 deletions(-)

diffs (23 lines):

diff -r 3c096d9564b0 -r 5270d6777557 
src-db/database/model/functions/FACT_ACCT_RESET.xml
--- a/src-db/database/model/functions/FACT_ACCT_RESET.xml       Mon Dec 10 
16:35:46 2012 +0100
+++ b/src-db/database/model/functions/FACT_ACCT_RESET.xml       Mon Dec 10 
16:39:25 2012 +0100
@@ -252,9 +252,7 @@
                     (SELECT 1
                     FROM C_YEAR, C_PERIOD, C_PERIODCONTROL, AD_Org, (SELECT 
fa.DATEACCT, fa.DOCBASETYPE, fa.ad_client_id, fa.record_id
                                                                        FROM 
FACT_ACCT fa 
-                                                                       WHERE 
fa.ad_table_id = Cur_Tables.AD_Table_ID
-                                                                       AND 
(v_Record_ID IS NULL OR fa.record_id = v_Record_ID)
-                                                                       ) fa_aux
+                                                                       WHERE 
fa.ad_table_id = Cur_Tables.AD_Table_ID) fa_aux
                     WHERE C_YEAR.c_year_id=C_PERIOD.c_year_id
                       AND C_PERIOD.c_period_id=C_PERIODCONTROL.c_period_id
                       AND C_YEAR.c_calendar_id=AD_Org.c_calendar_id
@@ -265,7 +263,7 @@
                                OR (fa_aux.DOCBASETYPE = 'GLJ' AND 
C_PERIOD.C_PERIOD_ID = FACT_ACCT.C_PERIOD_ID))
                       AND C_PeriodControl.AD_Org_ID=AD_Org.AD_Org_ID
                       AND C_PeriodControl.AD_Org_ID=v_AD_Org_CalOwner
-                     AND (v_Record_ID IS NULL OR fa_aux.record_id = 
FACT_ACCT.RECORD_ID)
+                      AND fa_aux.record_id = FACT_ACCT.RECORD_ID
                     )
                 AND Record_ID=(
                       CASE COALESCE(v_Record_ID, '0') WHEN '0' THEN Record_ID 
ELSE v_Record_ID

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits