Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0033872 | Openbravo ERP | Y. DBSourceManager | public | 2016-09-01 12:22 | 2016-09-01 13:20 |
| Reporter | AugustoMauch | ||||
| Assigned To | AugustoMauch | ||||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0033872: Provide the means to disable/reenable programatically all the indexes of the database | ||||
| Description | This can be very useful, for install the import.sample.data process is much faster if the data is imported with the indexes disabled. Importing a big sample data(+1.300.000 rows in a few transactional tables, +300.000 busines partners, etc) takes 522923 milliseconds with the indexes enabled, and 259161 ms (49.5% of the current metric) with the indexes disabled (this measure includes the time spent disabling and reenabling the indexes). Note that the data load was done in both cases using PostgreSQL's COPY functionality, instead of using dllutils' DataReader as usual. | ||||
| Steps To Reproduce | - | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2016-09-01 12:22 | AugustoMauch | New Issue | |||
| 2016-09-01 12:22 | AugustoMauch | Assigned To | => platform | ||
| 2016-09-01 12:22 | AugustoMauch | Modules | => Core | ||
| 2016-09-01 12:22 | AugustoMauch | Triggers an Emergency Pack | => No | ||
| 2016-09-01 12:22 | AugustoMauch | Assigned To | platform => AugustoMauch | ||
| 2016-09-01 13:18 | AugustoMauch | Description Updated | bug_revision_view_page.php?rev_id=13016#r13016 | ||
| 2016-09-01 13:20 | AugustoMauch | Description Updated | bug_revision_view_page.php?rev_id=13017#r13017 | ||
| There are no notes attached to this issue. |