Hello Guru's!
We use the GenerateGUID() function to generate a unique database record key on each database record. Only by default the database field of type text has a length of 50. Only does some one knows the maximum length of the GenerateGuid() output? So we can adjust the table field length on that.
Thanks in advance!
Hello @freek
The GenerateGUID() system action returns a 36 characters string (with hyphens).
For e.g: cfe2a8c6-319a-48a5-a42d-e278695795e6
The database field length of 50 is more than sufficient.
Regards,
AJ
Hi AJ, thnx for your reply! How about decreasing the 50 to 36 would that be safe?
Yes that is safe to do so.
In case you are planning to use GUIDs as Entity Identifiers, you will find this article by Justin James (OutSystems MVP), quite helpful.
Funny thing just happend I have a table with 33369 records in it and 3 guids in it. The size with the fields on 50 was 28 MB now I changed the fields from 50 to 36 and the size went up to 32 MB.
Just did another table to confirm with 2 guids in it it went from 14 to 19 MB!
Interesting, just curious, how/ where are you checking the size of the table. Can you share a screenshot plz?
Hi AJ, I'm using dbcleaneronsteroids: