Thanks to all of you for the valuable insights. Seems I’ve got some work to do ;-)
Regards, Rudy Mortier Two Way Communications bvba > On 24 Oct 2018, at 19:17, Chuck Miller via 4D_Tech <[email protected]> > wrote: > > 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 >> <[email protected]> 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 >>> <[email protected]> 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 < >>> [email protected]> 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:[email protected] >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
