[AccessD] Apples to oranges - take 2

'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.