[AccessD] Apples to oranges - take 2

ROTFL, yea you are right.

It is actually 67.6 million records.

Not exaggerating, just clicked send without rereading.  I had originally used an approximate number 
and later went back in and got the actual record count.  I pasted that in without removing the million.

Sorry guys.

John W. Colby
www.ColbyConsulting.com

On 10/7/2010 2:14 PM, Jurgen Welz wrote:
>
> '67564677 million records, 27 fields'
>
>
>
> I don't think there is an SSD or SSD RAID capable of that many bytes, even if you have only 4 bytes per record in a Long numeric ID and no other data in the fields.
>
> 67,564,677,000,000 is a lot of records.  Multiply by 4 bytes for a long PK = 270,258,708,000,000 Bytes.   You need 270 terabytes neglecting even the space for an index or any data.
> Add a first name and last name field with an average of 6 characters each and you need 810 terabytes before you index the names.  I think you're exaggerating
>
>
> Ciao
>
> Jürgen Welz
>
> Edmonton, Alberta
>
> jwelz at hotmail.com
>
>
>
>> Date: Wed, 6 Oct 2010 22:20:14 -0400
>> From: jwcolby at colbyconsulting.com
>> To: accessd at databaseadvisors.com; dba-vb at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
>> Subject: [AccessD] Apples to oranges - take 2
>>
>> OK, so I have two databases, each with a single table. BTW, these are two of my main tables, used
>> all of the time in orders.
>>
>> HSID - otherwise known as the database from hell, 51157068 records, ~560 fields. HSIDAllAdults is a
>> database where up to three adult names were lifted out of fields in HSID and placed in a table with
>> a PK_HSID field pointing back to the HSID record from which the information came. Thus
>> HSIDAllAdults is child to HSID in a manner of speaking (has a FK back to the PKID from HSID).
>> HSIDAllAdults has about 67564677 million records, 27 fields.