Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000497 | Openbravo ERP | A. Platform | public | 2008-05-30 16:59 | 2008-07-01 17:56 |
| Reporter | alostale | ||||
| Assigned To | alostale | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 2.40 | Fixed in Version | 2.40alpha-r3 | ||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0000497: Grid query optimization | ||||
| Description | The query to obtain data for the grid (TableSQLData class) can be modified in order to gain some performance specially for tabs with a huge number of records. Currently a number (depending on the tab) of left joins are evaluated for all the records before the application of the range delimiter. This delimiter can be applied before making only necessary to execute for all the records the left joins that affect to the fields in the order by clause. This bug is related with this issue: https://sourceforge.net/tracker/index.php?func=detail&aid=1863256&group_id=162271&atid=823129 [^] | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-05-30 16:59 | alostale | New Issue | |||
| 2008-05-30 16:59 | alostale | Assigned To | => cromero | ||
| 2008-05-30 16:59 | alostale | OBNetwork customer | => N | ||
| 2008-05-30 17:00 | alostale | Status | new => scheduled | ||
| 2008-05-30 17:00 | alostale | Assigned To | cromero => alostale | ||
| 2008-05-30 17:01 | svnbot | Checkin | |||
| 2008-05-30 17:01 | svnbot | Note Added: 0000393 | |||
| 2008-05-30 17:01 | svnbot | Status | scheduled => resolved | ||
| 2008-05-30 17:01 | svnbot | Resolution | open => fixed | ||
| 2008-05-30 17:01 | svnbot | svn_revision | => 4702 | ||
| 2008-06-11 12:46 | cromero | Target Version | => 2.40 | ||
| 2008-06-11 14:33 | cromero | Fixed in Version | => 2.40alpha r3 | ||
| 2008-06-19 14:01 | plujan | Status | resolved => closed | ||
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007913 | ||
| Notes | |||||
|
|
|||||
|
|
||||