Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030180Openbravo ERPA. Platformpublic2015-06-15 13:002018-01-04 02:59
Reportermtaal 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030180: Performance Improvement UUID Generation
DescriptionBy 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 ReproduceSee attached file for a proposed implementation
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? functions.sql (1,796) 2015-06-15 13:00
https://issues.openbravo.com/file_download.php?file_id=8206&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-06-15 13:00mtaalNew Issue
2015-06-15 13:00mtaalAssigned To => AugustoMauch
2015-06-15 13:00mtaalFile Added: functions.sql
2015-06-15 13:00mtaalOBNetwork customer => No
2015-06-15 13:00mtaalModules => Core
2015-06-15 13:00mtaalTriggers an Emergency Pack => No
2015-09-29 12:48AugustoMauchTarget Version3.0PR15Q4 =>
2018-01-04 02:49xeonnIssue Monitored: xeonn
2018-01-04 02:59xeonnNote Added: 0101541

Notes
(0101541)
xeonn   
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.