Projects:Improve UUID Generation
Introduction
The current UUID generation logic generates UUIDs which are very different from eachother.
There can be a benefit of generating UUIDs which are closer to eachother from an ordering/sorting point of view. This gives postgresql more opportunities to cache pages in memory and then access the cached data for subsequent imports.
This project should investigate what other UUID generation we can use. There is already a prototyped sql function for this. See the attached file in the tracking issue.
- Tracking issue: https://issues.openbravo.com/view.php?id=30180