| Author |
 Topic Search  Topic Options
|
macdonut 
Newbie
Joined: 08 March 2005
Location: United Kingdom
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access Database Size
Posted: 08 March 2005 at 7:22pm |
I've been meaning to get round to asking this many times but keep forgetting. So, now I've found this lovely site, I suspect this is a better place than many.
What is the largest size in Mb that it is safe to let an Access database grow to. The largest I use at the moment is about 23Mb. That one is purely for read only. If I had a read/write Access db, what size would be safe with that?
Cheers.
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 March 2005 at 9:12pm |
|
well "safe" is a good question. It really depends on what you do with it. If you i.e. Access Reports which can make the db inflate quite a bit I'd stop at 500MB a normal update, delete, insert db can theoretically go to 2GB thus 1GB is told to be a good limit, again all this also depends on how many people connect to it at a given time as it can corrupt quicker with many connections. But if you don't approach 100-200MB anyway there is nothing really to worry (local that is, I'd not use access for the web if I can avoid it)
|
|
|
|
macdonut
Newbie
Joined: 08 March 2005
Location: United Kingdom
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 March 2005 at 4:18am |
 Thanks for your response. Because, unfortunately, I can't avoid it at the moment, I was actually talking about Access on the web. But, I assume that with a good host then the db sizes shouldn't be much different - especially if I stick with about half the size of the figures you quote.
|
|
NISSANGTIR
Groupie
Joined: 20 April 2004
Location: United Kingdom
Status: Offline
Points: 85
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 April 2005 at 3:35pm |
I gather my 9mb access database is fine then??  ... And there was me wondering whether it was too big....lol
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 April 2005 at 3:44pm |
|
this can depend on the load of the server, the ammount of users on your website
|
|
JohnKn
Groupie
Joined: 22 March 2003
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 April 2005 at 6:12pm |
|
My Web Wiz forum db is at this moment 86.8 meg, forum pages still load
in well under 0.5 seconds most of the time (excluding searchs of
course). The forum and another site that hits a mySQL db are the most
traffic on this server so the machine isn't under much of a load.
Sooner or later I'll upgrade to MS SQL, unless borg or one of these other gentlemen get a mySQL version running.
|
|
NISSANGTIR
Groupie
Joined: 20 April 2004
Location: United Kingdom
Status: Offline
Points: 85
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 April 2005 at 3:59am |
When are you going to change then John?? Also how often to you compact and repair your database?? I am doing it everyday to be on the safe side 
|
|
JohnKn
Groupie
Joined: 22 March 2003
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 April 2005 at 10:05am |
|
I compact and repair every 2 or 3 days, the entire website is backed up
every night though so if the db did get corrupted I could replace it
with a db no more than 24 hours old.
I don't know when I'll update it to MS SQL, probably after I put more
ram in the server, it only has 256 meg right now, or when performance
starts to drop. I've gone through the process of upsizing the db a
couple times and documented all the little tweaks that need to be done
so I can do it whenever I need to.
|
|
