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
 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. ------------- 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??  ... 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 
|
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 |