By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Database size in relation to content

Nathan H
100+
P: 104
I have a strange question

Is there a method for determining the proper or standard size of a database (MB, GB) in regards to records and fields in the database?

I have a database with 30,000 records, with 10 fields per record. It just seems a little big in size even after compacting. No Code, No queries, just a table to run a catalog on a website.

Thanks.

Nathan
Dec 7 '07 #1
Share this Question
Share on Google+
4 Replies


JustJim
Expert 100+
P: 407
I have a strange question

Is there a method for determining the proper or standard size of a database (MB, GB) in regards to records and fields in the database?

I have a database with 30,000 records, with 10 fields per record. It just seems a little big in size even after compacting. No Code, No queries, just a table to run a catalog on a website.

Thanks.

Nathan
Hi Nathan,

Yes, it all depends on the datatypes of the fields in the table. Each datatype sets aside an amount of memory depending what it will be asked to store. Obviously a Boolean field (Yes/No) only uses a little bit (computer pun there!) of memory while a Double field uses more. You can multiply it all out and get the size that the table should take.

Don't forget that there is much more in an Access Application than just your table though. Try clicking on <Tools> <Options> <View> and put a tick in "System Objects" and looking in the Tables view of the Database Window. These system objects and other stuff will obviously add to the total size of your application over and above your one table.

Jim
Dec 7 '07 #2

Nathan H
100+
P: 104
Hi Nathan,

Yes, it all depends on the datatypes of the fields in the table. Each datatype sets aside an amount of memory depending what it will be asked to store. Obviously a Boolean field (Yes/No) only uses a little bit (computer pun there!) of memory while a Double field uses more. You can multiply it all out and get the size that the table should take.

Don't forget that there is much more in an Access Application than just your table though. Try clicking on <Tools> <Options> <View> and put a tick in "System Objects" and looking in the Tables view of the Database Window. These system objects and other stuff will obviously add to the total size of your application over and above your one table.

Jim

Thanks Jim, the System Objects revealed a lot!
Dec 7 '07 #3

JustJim
Expert 100+
P: 407
Thanks Jim, the System Objects revealed a lot!
Yes it does, now take the tick out of the box and don't mess with them ever again. Down that road lies madness, madnessss, madddnesss, I tell you.

'AveAGoodWeekend

Jim
Dec 7 '07 #4

Nathan H
100+
P: 104
Yes it does, now take the tick out of the box and don't mess with them ever again. Down that road lies madness, madnessss, madddnesss, I tell you.

'AveAGoodWeekend

Jim

Too Funny. Have a good one!
Dec 7 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.