Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004569Openbravo ERPI. Performancepublic2008-08-05 09:102008-12-19 08:58
Reporteropablo 
Assigned Toiperdomo 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40beta 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004569: Account selector is slow
DescriptionThe account selector is very slow with a great amount of data (>10000) in the system (business partners, projects, products and accounts)
Steps To ReproduceProduct -> Accounting -> Account Selector
Proposed SolutionIt seems this lack of performance is due to the combos in account selector (OB has to load all business partners, all projects and all products to load combos).

Maybe an option is to turn these combos into selectors.
Additional Information
Tagsperformance2.40scrum, Sprint-1
Relationships
depends on backport 0004928 closed iperdomo Account selector is slow 
depends on defect 0005250pi closed iperdomo Account selector is slow with a large dataset 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-05 09:10opabloNew Issue
2008-08-05 09:10opabloAssigned To => cromero
2008-08-05 09:10opablosf_bug_id0 => 2038500
2008-08-05 09:11opabloIssue Monitored: opablo
2008-08-14 10:09psarobePrioritynormal => low
2008-08-14 10:09psarobeSeveritymajor => minor
2008-08-14 10:09psarobeStatusnew => scheduled
2008-10-01 09:32cromeroAssigned Tocromero => shuehner
2008-10-01 15:49shuehnerRelationship addeddepends on 0005250
2008-10-01 17:43shuehnerAssigned Toshuehner => iperdomo
2008-10-02 13:58pjuvaraPrioritylow => high
2008-10-03 07:40iperdomoNote Added: 0009323
2008-10-03 07:40iperdomoStatusscheduled => feedback
2008-10-03 07:41iperdomoNote Edited: 0009323
2008-10-08 14:00opabloNote Added: 0009437
2008-10-13 10:11psarobeStatusfeedback => scheduled
2008-10-13 10:11psarobefix_in_branch => trunk
2008-10-24 17:36iperdomoTag Attached: performance2.40scrum
2008-10-24 17:48iperdomoTag Attached: Sprint-1
2008-10-30 15:15pjuvaraPriorityhigh => immediate
2008-10-31 10:20iperdomoStatusscheduled => resolved
2008-10-31 10:20iperdomosvn_revision => 7890
2008-10-31 10:20iperdomoResolutionopen => fixed
2008-12-19 08:58psarobeRegression testing => No
2008-12-19 08:58psarobeStatusresolved => closed

Notes
(0009323)
iperdomo   
2008-10-03 07:40   
(edited on: 2008-10-03 07:41)
Hi,

Changing the Business Partner, and Products from a combo to a Selector, and leaving Projects and Accounts (with Spain's accounting schema) as comboboxes we achieve a 74K html page size. Of course, the list of Projects and Campaings is zero.

Are you planning to have a large list of Projects? Do you think is necessary to change the Projects combobox to a selector?

Best Regards,

Iván
(0009437)
opablo   
2008-10-08 14:00   
Hi,

I'm not planning to have a huge amount of Projects.

Thanks!

Óscar