Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0030180 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2015-06-15 13:00 | 2018-01-04 02:59 | |||||||
| Reporter | mtaal | 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 | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0030180: Performance Improvement UUID Generation | |||||||||||
| Description | By generating UUIDs which are closer to eachother postgres has more opportunities to use cached pages of data. http://wiki.openbravo.com/wiki/Projects:Improve_UUID_Generation [^] | |||||||||||
| Steps To Reproduce | See attached file for a proposed implementation | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  functions.sql [^] (1,796 bytes) 2015-06-15 13:00 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0101541) xeonn (reporter) 2018-01-04 02:59 |
Hi, Can this issue be expedited? I have done some research (google) and I think this is the main source of system slowdown. The current random UUID will scatter writes across the database and causes exponential system slowdown within a year data. Several blogs I came across mentioned that using UUID v1 will be the preferred method. (As per attached functions.sql. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-06-15 13:00 | mtaal | New Issue | |
| 2015-06-15 13:00 | mtaal | Assigned To | => AugustoMauch |
| 2015-06-15 13:00 | mtaal | File Added: functions.sql | |
| 2015-06-15 13:00 | mtaal | Modules | => Core |
| 2015-06-15 13:00 | mtaal | Triggers an Emergency Pack | => No |
| 2015-09-29 12:48 | AugustoMauch | Target Version | 3.0PR15Q4 => |
| 2018-01-04 02:49 | xeonn | Issue Monitored: xeonn | |
| 2018-01-04 02:59 | xeonn | Note Added: 0101541 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |