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] **********************************************************************
