details: /erp/devel/pi/rev/92dd3f29a38e
changeset: 7888:92dd3f29a38e
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Thu Jul 15 15:44:44 2010 +0200
summary: Fixes issue 0013775: Business partners and Products take a lot of
time to insert when the database is big
diffstat:
src-db/database/model/tables/AD_TREENODEBP.xml | 4 ++++
src-db/database/model/tables/AD_TREENODEPR.xml | 4 ++++
2 files changed, 8 insertions(+), 0 deletions(-)
diffs (28 lines):
diff -r 56efb4e6c8a7 -r 92dd3f29a38e
src-db/database/model/tables/AD_TREENODEBP.xml
--- a/src-db/database/model/tables/AD_TREENODEBP.xml Thu Jul 15 13:38:51
2010 +0200
+++ b/src-db/database/model/tables/AD_TREENODEBP.xml Thu Jul 15 15:44:44
2010 +0200
@@ -61,6 +61,10 @@
<index name="AD_TREENODEBP_PARENT" unique="false">
<index-column name="PARENT_ID"/>
</index>
+ <index name="AD_TREENODEBP_PARENT2" unique="false">
+ <index-column name="AD_TREE_ID"/>
+ <index-column name="PARENT_ID"/>
+ </index>
<unique name="AD_TREENODEBP_TREE_NODE_UN">
<unique-column name="AD_TREE_ID"/>
<unique-column name="NODE_ID"/>
diff -r 56efb4e6c8a7 -r 92dd3f29a38e
src-db/database/model/tables/AD_TREENODEPR.xml
--- a/src-db/database/model/tables/AD_TREENODEPR.xml Thu Jul 15 13:38:51
2010 +0200
+++ b/src-db/database/model/tables/AD_TREENODEPR.xml Thu Jul 15 15:44:44
2010 +0200
@@ -61,6 +61,10 @@
<index name="AD_TREENODEPR_PARENT" unique="false">
<index-column name="PARENT_ID"/>
</index>
+ <index name="AD_TREENODEPR_PARENT2" unique="false">
+ <index-column name="AD_TREE_ID"/>
+ <index-column name="PARENT_ID"/>
+ </index>
<unique name="AD_TREENODEPR_TREE_NODE_UN">
<unique-column name="AD_TREE_ID"/>
<unique-column name="NODE_ID"/>
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
