Database Size

  • Thread starter Thread starter Gary S
  • Start date Start date
G

Gary S

I have a database that is approaching 2 gigs.
This database has around 260 tables in it.
I want to figure out which tables are taking
up the most room, so I can archive some of that
information and thereby reduce the size of the
database.

Is there a better way than just manually looking
at record count to determine the largest tables?
 
The first thing to consider is are you stroring any graphic or other files in
your tables? If so, they should be taken out of the database and housed in a
specific folder and referenced using hyperlink or text fields to point to the
location.

The next thing to look at is the design. Are you carrying duplicated data?
for example, do you have tables where the same piece of text data is used
over and over again? This is a design flaw. If you have a text data item
that is used repeatedly either in one table or in multiple tables, that data
item should be moved to it's own table with an autonumber field added and
that auotnumber field used in your other tables as a link to the text value.
That will save some space.

250 tables seems like a lot of tables. It is possible you could move some
of them to another mdb? A front end application can link to many back end
databases.

Or, maybe it is time to seriously consider upsizing to SQL server.

But, in any case, without completely analyzing your database, no real answer
can be provided.

Just checking the recordcount wont really tell you much. You also need to
know what the size of a record is. That, unfortunately, is not that easy to
discern.
 
Back
Top