Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0024653 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2013-09-02 12:03 | 2013-09-02 13:03 | |||||||
| Reporter | azabaleta | View Status | public | |||||||||
| Assigned To | dmiguelez | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0024653: c_Locfrom_Id,c_Locto_Id columns in fact_acct make the application go slower. Wrong AD reference definition. | |||||||||||
| Description | The log shows e280dd67 07:12:17 [ajp-8009-3] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Financial Account, in tab Accounting History the combo fields inpcLocfromId,inpcLoctoId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo. | |||||||||||
| Steps To Reproduce | Run Openbravo Import 10.000 business partners with addresses | |||||||||||
| Proposed Solution | Change the column reference definition in Openbravo AD | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0060861) azabaleta (developer) 2013-09-02 13:03 |
Also C_PROJECT_ID has same problem in FACT_ACCT table. I would suggest going through all tables in "Tables and Columns" and change all C_PROJECT references to fix the whole potential problem instead of only in FACT_ACCT |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-09-02 12:03 | azabaleta | New Issue | |
| 2013-09-02 12:03 | azabaleta | Assigned To | => dmiguelez |
| 2013-09-02 12:03 | azabaleta | Modules | => Core |
| 2013-09-02 12:03 | azabaleta | Triggers an Emergency Pack | => No |
| 2013-09-02 13:03 | azabaleta | Note Added: 0060861 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |