patternMinor
Acceptable size for MS Access Database?
Viewed 0 times
sizedatabaseforacceptableaccess
Problem
I have developed an Access 2010 database.
It has three main tables:
It also has a bunch of small lookup tables for some of the fields in the houses table.
Right now I have about 100 houses listed and only about 5-10 contacts and visits.
I'm expecting at its peak this database will hold 300-500 houses, with 3-5 contacts and visits for each.
Right now the database size is about 50 MB. I realize I didn't compact/repair it while I was building it or initially populating it which might be one problem. It seems to run very slow. Has this database grown too much? Is this a typical size for a database of this scope?
(I'm on windows 7 with 8 gig RAM so I don't think my own computer is the issue)
It has three main tables:
HOUSES
id,
address,
number_stories,
garden,
parking,
imageAttachments (~1-4 per record),
etc...,
about 60 fields total
CONTACTS
id,
houses.id(fk),
contactType(owner, manager, etc),
contactEmail,
contactPhone
VISITS
id,
Contacts.id(fk),
Houses.id(fk),
visitDate,
visitNotesIt also has a bunch of small lookup tables for some of the fields in the houses table.
Right now I have about 100 houses listed and only about 5-10 contacts and visits.
I'm expecting at its peak this database will hold 300-500 houses, with 3-5 contacts and visits for each.
Right now the database size is about 50 MB. I realize I didn't compact/repair it while I was building it or initially populating it which might be one problem. It seems to run very slow. Has this database grown too much? Is this a typical size for a database of this scope?
(I'm on windows 7 with 8 gig RAM so I don't think my own computer is the issue)
Solution
I've had Access databases of 1.5 GB (7 years ago on a machine much weaker than what you've described) run fine - for some queries. It really depends on what you are querying and how it's indexed. Without knowing the details of the queries and reports you're running, I can't say if it's too slow or not (and you don't actually define slow: 10 seconds? 2 seconds? 3 hours?) . I know in the past that Access had a 2GB file-size limit. I don't know if recent versions have changed that.
Context
StackExchange Database Administrators Q#15735, answer score: 2
Revisions (0)
No revisions yet.