Database Limitation

[jay2502]

I'm planning to create a database that will hold +- 1.7 million records per year and I've checked the size limitation and it will not be a problem! my question is Will the amount of data cause a lag how bad do you think the lag will be! Any thoughts will be appreciated

 

[Ed2020]

It depends on the table structure, no of fields, data types, etc; no of users, what the users are doing, network capability...

For what it's worth I have a system that utilises a table with well over 2.5 million records with no performance problems at all.

Ed Metcalfe.

Please do not feed the trolls.....

 

[JerryKlmns]

Depends on

The folder where the mdb resides (local/server)
How many will be accessing on the same time if it resides on server
Network bandwidth
How well normalized is
Use of domain aggregate functions
Use of functions

If its use is just for reporting then a "flat databse file" structure should speed things up

You are asking a general question here!