No it is just painful let’s assume for some reason record in a many table where assigns to wrong main table which would you rather type in to fix 145764 or a 32 character UUID In my opinion the journal aspect should have been hidden by 4D and the UUID field should have been there but hidden
Regards Chuck Sent from my iPhone > On Oct 24, 2018, at 11:59 AM, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > RE: never use them to link between tables > > Is using them to link between tables (establish 4D Relations, correct?) a > hazardous practice? > > Thanks, > Keith - CDI > >> On Oct 24, 2018, at 10:49 AM, Charles Miller via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> Rudy >> >> For me this always choose UUID for primary key and never use them to link >> between tables. The overhead from space is not so great Andy I never want >> to type in uuid to find related records etc >> >> Regards >> >> Chuck >> >> On Wed, Oct 24, 2018 at 10:52 AM Two Way Communications via 4D_Tech < >> 4d_tech@lists.4d.com> wrote: >> >>> I have an application with a big database file ( + 60 GB), with 128 >>> tables. (4D v17) >>> >>> All id fields and foreign keys are of type longint. >>> >>> Now, for replication and sharing purposes, I would like to change the type >>> to UID. >>> >>> The process seems quite cumbersome: to start, I need to remove the >>> ‘primary key’ flag from all the ID fields, then I need to add UID fields to >>> every table, >>> change the foreign keys as well, and use apply formula to make sure the >>> relations are intact. I am a bit worried that this will have a major impact >>> on the size of the data file. >>> >>> Furthermore, I need to automate the whole process so the upgrade works >>> flawlessly at the customers site. >>> >>> Has anyone ever done this? >>> Any tips? >>> >>> Regards, >>> >>> Rudy Mortier >>> Two Way Communications bvba >>> >>> > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
