Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002564Openbravo ERPI. Performancepublic2008-01-29 19:212008-11-26 13:54
jpabloae 
alostale 
normalminoralways
closedfixed 
5
 
2.40alpha-r2 
No
Core
No
0002564: OBN: Only active fields should be relected in queries
Performance issue:

"In the relation-views Openbravo does a select on all field of that
specific table. If there are a lot of record like in Products, it also
takes to long for the data to load. Is it possible to change the WAD
builder, so that only active fields are selected in the query? For
instance, Products, there are only 8 fields that are active to be viewed
in the relation mode, yet there are more that 20 or 30 fields selected
in the query."

Affected versions: 2.35, 2.35MP1
DB: any
OS: any
No tags attached.
Issue History
2008-11-26 13:54psarobeRegression testing => No
2008-11-26 13:54psarobeStatusresolved => closed

Notes
(0006153)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1881979 [^]
(0003111)
alostale   
2008-02-06 12:19   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500722
Originator: NO

Fixed applying this patch: https://sourceforge.net/tracker/index.php?func=detail&aid=1811346&group_id=162271&atid=823129 [^]