Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004577Openbravo ERPI. Performancepublic2008-08-05 10:232008-11-25 16:56
opablo 
shuehner 
urgentminoralways
closedunable to reproduce 
5Any
pi 
 
Core
No
0004577: Access via Edit Mode instead to access to grid
When accessing an entity via Edit mode instead of Grid mode, OB performs the select to find all registers when it only has to retrieve the editing record.
Store the ID in session and find directly the record
Performance, performance2.40scrum, Sprint-3
Issue History
2008-08-05 10:23opabloNew Issue
2008-08-05 10:23opabloAssigned To => cromero
2008-08-05 10:23opablosf_bug_id0 => 2038572
2008-08-05 10:23opabloIssue Monitored: opablo
2008-08-14 09:08psarobeSeveritymajor => minor
2008-08-14 09:08psarobeStatusnew => scheduled
2008-08-14 09:08psarobefix_in_branch => trunk
2008-08-26 14:01pjuvaraNote Added: 0008754
2008-08-26 14:01pjuvaraStatusscheduled => feedback
2008-09-16 17:22cromeroAssigned Tocromero => shuehner
2008-10-02 13:50pjuvaraStatusfeedback => new
2008-10-02 13:50pjuvaraStatusnew => acknowledged
2008-10-02 13:51pjuvaraNote Added: 0009317
2008-10-02 13:58pjuvaraPrioritynormal => high
2008-10-30 15:15pjuvaraPriorityhigh => immediate
2008-11-03 10:37rafarodaTag Attached: Performance
2008-11-07 08:57pnudingNote Added: 0010060
2008-11-07 08:57pnudingPriorityimmediate => urgent
2008-11-07 08:57pnudingfix_in_branchtrunk =>
2008-11-19 13:09iperdomoTag Attached: performance2.40scrum
2008-11-19 13:09iperdomoTag Attached: Sprint-3
2008-11-19 14:33shuehnerStatusacknowledged => scheduled
2008-11-19 14:33shuehnerfix_in_branch => trunk
2008-11-19 14:43shuehnerNote Added: 0010409
2008-11-19 14:43shuehnerStatusscheduled => feedback
2008-11-25 10:14opabloNote Added: 0010601
2008-11-25 16:56shuehnerRegression testing => No
2008-11-25 16:56shuehnerStatusfeedback => closed
2008-11-25 16:56shuehnerNote Added: 0010652
2008-11-25 16:56shuehnerResolutionopen => unable to reproduce

Notes
(0008754)
pjuvara   
2008-08-26 14:01   
Please restate the issue as a problem and not a suggested solution.

Are you experiencing too long of a delay opening a window in edit mode? If so, which one? How long are you waiting for? What is your data distribution, etc?
(0009317)
pjuvara   
2008-10-02 13:51   
We know that the issue reproduces, we still need to figure out possible solution before scheduling the fix.
(0010060)
pnuding   
2008-11-07 08:57   
Issue is scheduled for resolution in Sprint 3 of the Performance project - as discussed with PJuvara reduced priority to urgent to avoid confusion
(0010409)
shuehner   
2008-11-19 14:43   
I did review the code involved in the access an entity via Edit mode. If this is the first access in the session either an empty window is shown and the search popup is opened (example: Business Partner). In Grid mode (example: Sales Orders) either all record are displayed or a filter to find "recent"/unprocessed transaction is applied (for windows marked as transactional).

When a entity is accessed in Edit mode the last shown record is already saved in the session and used when the window is opened again.

I could not find a case where all records are loaded and only one is shown.

But, related to the navigation buttons and switching to grid mode a different query is used to get the index/position of the current record inside the selected records. This query does return multiple/lots of records, but only the id-field for each of them.

In the current sprint we are working on performance improvements for this navigation and the transactional filters, which improve the response time very much.

Can you please recheck this bug and give me an example of where all records are loaded for displaying a single one in Edit Mode, because i could not find a reproducible case where this happens. Or is the bug about the navigation issue above which loads many records (but only the id-column).
(0010601)
opablo   
2008-11-25 10:14   
I have not been able to reproduce this issue again, so I suppose it is already solved.

Sorry for the inconvenience
(0010652)
shuehner   
2008-11-25 16:56   
Close issue after info from reporter that he cannot reproduce the bug anymore.