Print Page | Close Window

Access Database Size

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14162
Printed Date: 29 March 2026 at 7:49pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Access Database Size
Posted By: macdonut
Subject: Access Database Size
Date 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.


-------------
Macdonut
http://www.mypd.co.uk/search - MyPD UK Search Directory



Replies:
Posted By: michael
Date 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)

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: macdonut
Date Posted: 09 March 2005 at 4:18am
ClapThanks 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.

-------------
Macdonut
http://www.mypd.co.uk/search - MyPD UK Search Directory


Posted By: NISSANGTIR
Date Posted: 22 April 2005 at 3:35pm
I gather my 9mb access database is fine then??  Embarrassed...  And there was me wondering whether it was too big....lol


Posted By: dj air
Date Posted: 22 April 2005 at 3:44pm
this can depend on the load of the server, the ammount of users on your website



Posted By: JohnKn
Date 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.


Posted By: NISSANGTIR
Date 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 Confused


Posted By: JohnKn
Date 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.


Posted By: xenophine
Date Posted: 22 December 2006 at 12:13am
i have about 6000 users, 40.000 messages and max online user at one time is nearly 10.. my access db size is 100 mb and i'm using wwf v7.9.. i didnt have any error or slowing yet.

(1)but sometimes while clicking to a link, connection dont responses about thirty seconds and then loads the page fastly. i think it is about my host. isnt it? or this is a database slowment?

(2)am i have to change my server to SQL? or can i continue it until nearly 500 mb access database with these online statistic?

what is your opinions about these statistics and growing? sorry for my bad english:) and regards..

-------------
http://www.birdukkan.com - birdukkan.com


Posted By: xenophine
Date Posted: 26 December 2006 at 4:43pm
please help me, i'm in a trouble..

don't say "change your database to sql". i know i have to..

but i want to learn, my access database can go until what growth?
i'm having slowments and time outs because of the 100 mb access db with nearly 10-20 connections at the same time.
is it true, are these statistics are big for a web wiz forums 7.9 with access database?


-------------
http://www.birdukkan.com - birdukkan.com


Posted By: WebWiz-Bruce
Date Posted: 27 December 2006 at 10:39am
For a forum that size Access database is way to much because of the amount of read and writes performance on the database to get all the data, however, if you really can't use SQL Server or mySQL you should at very least upgrade to version 8 not only for security, but also because it has been highly optimised cutting many pages from over 30 database hits down to no more than 2 or 3 for most pages so would be much better and faster and many less database hits so less chance of database corruption.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: xenophine
Date Posted: 27 December 2006 at 1:30pm
thanks for your answer boRg. i can use mysql server on my host.. but it's too hard to change db type, cuz i'm beginner at databases :) i will try, i hope i can.

-------------
http://www.birdukkan.com - birdukkan.com



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net