Re: SQL and GRID object

Article View: borland.public.vdbase.data.sql

Article #773

Back to borland.public.vdbase.data.sql Previous Next

#773

From: Doug MacKinnon
Date: Wed, 15 Jul 1998 00:00

22 lines
1233 bytes

Romain Strieff [TeamB] wrote in message ...
>> The CUSTOMER database has a field "Customer ID" autoincrement.
>> The FULFILLMENT database has a field "Customer ID"  numeric, width 6
>>
>Use a LONG in the FULFILLMENT table.
>--
>Romain Strieff [TeamB]

I have changed it because I'm obedient. 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.

Technical Details

Message-ID: <6ojkar$71p11@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@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: "Doug MacKinnon" <dmack@home.com>
Subject: Re: SQL and GRID object
Date: 1998/07/15
Message-ID: <6ojkar$71p11@forums.borland.com>
X-Deja-AN: 371871626
References: <6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message