Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025256Openbravo ERPA. Platformpublic2013-11-29 12:062014-02-03 13:42
jonalegriaesarte 
jonalegriaesarte 
normalmajorhave not tried
closedduplicate 
5
 
3.0PR14Q2 
OBPS
Core
25055
No
0025256: Create lines from takes too long to load the first time, when the volume of data is high
Create lines from takes too long to load the first time, when the volume of data is high
We need a database with a high volume of data in c_order, c_orderline, m_inout and m_inoutline
- Purchase invoice
- Create lines from
Pending to be analyzed in depth
Performance
duplicate of defect 00253543.0MP31 closed dmiguelez Takes long to show the create from invoices popup 
Issue History
2013-11-29 12:06jonalegriaesarteNew Issue
2013-11-29 12:06jonalegriaesarteAssigned To => jonalegriaesarte
2013-11-29 12:06jonalegriaesarteModules => Core
2013-11-29 12:06jonalegriaesarteOBNetwork customer => Yes
2013-11-29 12:06jonalegriaesarteSupport ticket => 25055
2013-11-29 12:06jonalegriaesarteTriggers an Emergency Pack => No
2013-11-29 12:06jonalegriaesarteTag Attached: Performance
2013-12-03 01:24egoitzNote Added: 0062496
2014-01-02 12:38jonalegriaesarteTarget Version3.0MP31 => 3.0MP32
2014-02-03 13:42jonalegriaesarteRelationship addedduplicate of 0025354
2014-02-03 13:42jonalegriaesarteNote Added: 0063862
2014-02-03 13:42jonalegriaesarteStatusnew => closed
2014-02-03 13:42jonalegriaesarteResolutionopen => duplicate

Notes
(0062496)
egoitz   
2013-12-03 01:24   
posible solution:


CREATE INDEX m_matchinv_inout
  ON m_matchinv
  USING btree
  ( m_inoutline_id COLLATE pg_catalog."default" );


analyze m_matchinv
(0063862)
jonalegriaesarte   
2014-02-03 13:42   
Solved in changeset https://code.openbravo.com/erp/devel/pi/rev/6d69e73928db [^]