Maximum Records

[Jim Thomlinson]

That I am aware of there is no physical limit to the number of records in a
table. In your opionion is there a practical limit past which you would not
want to exceed. The database that I am looking at creating is not
transactional. It will store a large amount of historical data pulled from 2
different systems and will be queried purely for analytical purposes. A data
warehouse kind of a thing. Performance does not need to be stellar but it can
not be entirely unreasonable.

 

[Duane Hookom]

Depending on the number of users, you should be able to query/report 1
million+ records.
You may need to create key indexes to optimize your performance.

 

[Jim Thomlinson]

If it went to 3 or 5 million would that be acceptable. I would possilbly be
running a small number of front ends supported by the one back end. Access
2000. Query times in the minutes range would be acceptable as this is purely
analytical.

The extraction of data from the two systems will take a while and I would
hate to get everything loaded only to find out that the performance is in the
range of hours...
--
HTH...

Jim Thomlinson

Depending on the number of users, you should be able to query/report 1
million+ records.
You may need to create key indexes to optimize your performance.

 

[John Vinson]

That I am aware of there is no physical limit to the number of records in a
table. In your opionion is there a practical limit past which you would not
want to exceed. The database that I am looking at creating is not
transactional. It will store a large amount of historical data pulled from 2
different systems and will be queried purely for analytical purposes. A data
warehouse kind of a thing. Performance does not need to be stellar but it can
not be entirely unreasonable.

The largest Access table in production use of which I am aware (there
may be more!) had some 20,000,000 records; this was a couple of years
ago. (And it was in Access 2.0!)

Just as a test, I created a database (1.85 GByte as I recall) with an
indexed, two-field, 50,000,000 row table. I don't recall the actual
search times but they were in the "a couple of minutes" range, not
hours - and that was retrieving and sorting reasonably large subsets.

John W. Vinson[MVP]

 

[Jim Thomlinson]

Thanks all for the responses... I am going to try to keep it in the 3 to 5
million ball park. As always you are an invaluable resource...
--
HTH...

Jim Thomlinson