Subject | GEN_UUID performance |
---|---|
Author | homerjones1941 |
Post date | 2011-03-19T17:34:37Z |
Using the IBExpert Log Manager, I created 23 triggers that record changes to selected tables and fields. The tables that store those log entries use an auto-increment integer as primary key. A few of the tables that are being logged are very active. I worry that, over time, the integer field might reach its limit. I am considering replacing the integer PK with a GUID/UUID. Can anyone tell me if there is much of a performance hit when using GEN_UUID? Also, any tips/precautions would be appreciated.