details: https://code.openbravo.com/erp/devel/pi/rev/0b70358a2e29
changeset: 33829:0b70358a2e29
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Fri Apr 13 09:35:13 2018 +0200
summary: fixed 38289: slow Log Clean Up with records in AD_PROCESS_REQUEST
using Groups
Added index to ad_process_request.ad_process_request_group_id to prevent seq
scans when deleing on this table having requests linked to groups.
diffstat:
src-db/database/model/tables/AD_PROCESS_REQUEST.xml | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diffs (14 lines):
diff -r eac492d3b3d2 -r 0b70358a2e29
src-db/database/model/tables/AD_PROCESS_REQUEST.xml
--- a/src-db/database/model/tables/AD_PROCESS_REQUEST.xml Mon Dec 11
10:45:43 2017 -0500
+++ b/src-db/database/model/tables/AD_PROCESS_REQUEST.xml Fri Apr 13
09:35:13 2018 +0200
@@ -227,6 +227,10 @@
<foreign-key foreignTable="AD_PROCESS_REQUEST"
name="AD_PROCESS_REQUEST_GROUP">
<reference local="AD_PROCESS_REQUEST_GROUP_ID"
foreign="AD_PROCESS_REQUEST_ID"/>
</foreign-key>
+ <index name="AD_PROCESS_REQGROUP_IDX" unique="false">
+ <index-column name="AD_PROCESS_REQUEST_GROUP_ID"/>
+ <whereClause><![CDATA[AD_PROCESS_REQUEST_GROUP_ID IS NOT
NULL]]></whereClause>
+ </index>
<check name="AD_PROCESS_REQUEST_GROUP_CHK"><![CDATA[ISGROUP = 'Y' AND
AD_PROCESS_GROUP_ID IS NOT NULL OR ISGROUP = 'N' AND AD_PROCESS_GROUP_ID IS
NULL]]></check>
<check name="AD_PROCESS_REQUEST_ISGROUP_CHK"><![CDATA[ISGROUP IN ('Y',
'N')]]></check>
<check name="AD_PROCESS_REQUEST_PROCESS_CHK"><![CDATA[AD_PROCESS_ID IS
NOT NULL AND AD_PROCESS_GROUP_ID IS NULL OR AD_PROCESS_GROUP_ID IS NOT NULL AND
AD_PROCESS_ID IS NULL]]></check>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
