Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0033872 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2016-09-01 12:22 | 2016-09-01 13:20 | |||||||
| Reporter | AugustoMauch | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| 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 | 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 | - | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | View Revisions |
| 2016-09-01 13:20 | AugustoMauch | Description Updated | View Revisions |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |