Project:
| View Revisions: Issue #30659 | [ Back to Issue ] | ||
| Summary | 0030659: Improve the generation of UUIDs so that they can be indexed more efficiently | ||
| Revision | 2015-08-25 09:00 by AugustoMauch | ||
| 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 [^] |
||
| Revision | 2015-08-25 08:55 by AugustoMauch | ||
| 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 [^] |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |