Article View: borland.public.vdbase.data.sql
Article #778Re: SQL and GRID object
From: Romain Strieff [TeamB]
Date: Thu, 16 Jul 1998 00:00
Date: Thu, 16 Jul 1998 00:00
34 lines
1617 bytes
1617 bytes
In article <6ojkar$71p11@forums.borland.com>, dmack@home.com grudgingly admits... > >-- > >Romain Strieff [TeamB] > > I have changed it because I'm obedient. ---- <G> > But why would you suggest this? Is > it: > > a) speed? > b) re-usability of the tables? > c) relation may not compare properly? > -from what I've tested it worked fine. > d) scalability? > -I have 70,000 customers, increasing at about 3%/year; I'll be dead > before I need a width of 7, and then it would be easy to change anyway. > e) something I know nothing about? > > Thanks. ----- Both fields in a relation should be the same type. For example your AUTOINC could be (in a couple of moths) 1999999999 and your child table not having enough place to represent that it would store only partial/no key, therefore endangering your data consistancy since it could post to the wrong parent or none at all. Not to mention that a long being 4 chrs wide (255*255*255*255) there's a bit of HD space gain. ;-) -- Romain Strieff [TeamB]
Technical Details
Message-ID:
<MPG.1017b1bed968a9e98afca@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@forums.borland.com> <6ojkar$71p11@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,9780f046f4c80b16 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: SQL and GRID object Date: 1998/07/16 Message-ID: <MPG.1017b1bed968a9e98afca@forums.borland.com> X-Deja-AN: 371943186 References: <6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@forums.borland.com> <6ojkar$71p11@forums.borland.com> Organization: TeamB Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql