Record capacity Northwind

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.
 
Jim,

Well now, that is a tricky question... There are many factors to tkae into
account. How big is the table? How many fields are in the tables? What
are the field data types? Do you run Compact & Repair weekly? What is the
rate of data entry? Are you running a lot of action queries? Any
Maek-Table queries?

I've got tables with well over 300,000 records in it and it will be years
before that thing ever reaches 2 gig. Why don't we start with what are you
doing?

On another note, let's not post your real eMaill Address for the Spammers to
get a hold of....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Jim said:
Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.
Click to expand...

That's hard to say. I have 1 database with over 6 million records in it and
it is just over 1.1 GB. I have another that gets about 100,000 records every
day, but they are only 32 bytes each. Data that's over 5 years old is
archived, so the data will never be over 1/2 a GB.

Northwind is not a very efficient database design, but even it will hold
more than a million records if the images are stored out of the database.
 
Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.
Click to expand...

How many boxes will fit in a 24 foot moving van?

There are small records and big records; Access trims trailing blanks in text
fields and memos, and NULL values take up no space at all, so there is no
defined size to a record, even if the field definitions all have a specific
(maximum) size.
 
Back
Top