Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035922 | Openbravo ERP | I. Performance | public | 2017-05-04 10:11 | 2017-05-29 17:43 |
|
| Reporter | Sandrahuguet | |
| Assigned To | Sandrahuguet | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035922: It is better for performance to change columns order in c_bpartner_idsalesrep index |
| Description | It is better for performance to change columns order in c_bpartner_idsalesrep index
|
| Steps To Reproduce | N/A |
| Proposed Solution | CREATE INDEX c_bpartner_idsalesrep
ON c_bpartner
USING btree
(issalesrep COLLATE pg_catalog."default", c_bpartner_id COLLATE pg_catalog."default",);
|
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0020247 | | closed | egoitz | Long time to load order or invoices windows when having 600k partners |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-05-04 10:11 | Sandrahuguet | New Issue | |
| 2017-05-04 10:11 | Sandrahuguet | Assigned To | => Triage Finance |
| 2017-05-04 10:11 | Sandrahuguet | OBNetwork customer | => No |
| 2017-05-04 10:11 | Sandrahuguet | Modules | => Core |
| 2017-05-04 10:11 | Sandrahuguet | Triggers an Emergency Pack | => No |
| 2017-05-04 10:13 | Sandrahuguet | OBNetwork customer | No => Yes |
| 2017-05-04 10:13 | Sandrahuguet | Resolution time | => 1495663200 |
| 2017-05-04 10:13 | Sandrahuguet | Tag Attached: Performance | |
| 2017-05-04 15:22 | hgbot | Checkin | |
| 2017-05-04 15:22 | hgbot | Note Added: 0096385 | |
| 2017-05-04 15:22 | hgbot | Status | new => resolved |
| 2017-05-04 15:22 | hgbot | Resolution | open => fixed |
| 2017-05-04 15:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/28a1d2e81f5d26a4e2f9da0401bfa68012d1e689 [^] |
| 2017-05-04 15:24 | Sandrahuguet | Assigned To | Triage Finance => Sandrahuguet |
| 2017-05-04 15:37 | Sandrahuguet | Relationship added | related to 0020247 |
| 2017-05-04 16:34 | aferraz | Review Assigned To | => aferraz |
| 2017-05-04 16:34 | aferraz | Note Added: 0096396 | |
| 2017-05-04 16:34 | aferraz | Status | resolved => closed |
| 2017-05-04 16:34 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096939 | |