Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0030659 | Openbravo ERP | A. Platform | public | 2015-08-25 08:55 | 2019-02-14 07:53 |
|
| Reporter | AugustoMauch | |
| Assigned To | AugustoMauch | |
| Priority | normal | Severity | minor | 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 | 0030659: Improve the generation of UUIDs so that they can be indexed more efficiently |
| Description | Openbravo uses the uuid_generate_v4 [1] function to generate UUIDs with PostgreSQL. The function generates randomized UUIDs that are very scattered, which is makes the updates of the indexes based on these UUIDs very slow.
The index updates could potentially be much more efficient if the UUIDs were more grouped
[1] http://www.postgresql.org/docs/9.4/static/uuid-ossp.html [^] |
| Steps To Reproduce | - |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-08-25 08:55 | AugustoMauch | New Issue | |
| 2015-08-25 08:55 | AugustoMauch | Assigned To | => AugustoMauch |
| 2015-08-25 08:55 | AugustoMauch | Modules | => Core |
| 2015-08-25 08:55 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2015-08-25 09:00 | AugustoMauch | Description Updated | bug_revision_view_page.php?rev_id=9263#r9263 |
| 2019-02-14 07:53 | pramodkumar | Note Added: 0109817 | |