HI i'm looking to create a backend database that will be growing at a rate of about 250,000 per day.
What i have in mind is a single table stored on a NAS unit . The table will have about 20 text fields per record
The front end will be updating the backend table every minute with approx 500 records.
All the queries / forms (functionality) will be managed via the front end (again MSAccess)
My concern is any limitations the BE will have due to file size? Someone suggested using MySQL but i don't have any experience with this.
Again the size of this table will be substantial (250,000 records/day = 5,000,000 per month = 600,000,000 records in 1 year.)
I can split the table into smaller tables if that will help the cause but again i'm not sure it would?
The other consideration i have is the hardware requirements to factor into this application. Do i need a 64bit vs 32 bit computer? will this be enough?
Any thoughts on the design and hardware requirements to make this function would be appreciated.
Thanks in advance.