Print Page | Close Window

How much space needed for database?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10032
Printed Date: 08 April 2026 at 5:01am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: How much space needed for database?
Posted By: thustra
Subject: How much space needed for database?
Date Posted: 17 April 2004 at 11:30am

I appreciate this is like asking how long is a piece of string, but approximately how large will the access database file grow on a medium sized website? I ask because I have 50Meg, and I'm unsure how many messages (minus image hosting) might be posted before it starts to get a bit full! Has anyone else had problems with their forum growing too fast, and can the database be stored on another server from the forum code?

Many thanks in advance to a reply,

(and Bruce, you are a god-send!!)




Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 April 2004 at 12:30pm
I foud a ruff average is aound 1MB for each 1000 messages posted.

But beaware that access is a flat file database system and as such performance will detertiate the larger the file size. Most hosts will have a round a 10 to 20Mb limit on Access file sizes.

For large sites you should really look at MS SQL Server, yoi can get some very cheap hosting options these days with support for MS SQL server 2000.


-------------
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: dpyers
Date Posted: 17 April 2004 at 2:13pm
You may want to pull your access db offline and do a compact & repair.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: thustra
Date Posted: 17 April 2004 at 3:25pm

Hi Borg, thanks for info, I appreciate it.

I found a cheap hosting service, but to upgrade to a MS SQL server it's £380 / year!!  Hopefully with mine being a smallish site, I will not run into such problems. I can always archive if it becomes the case.



Posted By: michael
Date Posted: 17 April 2004 at 11:49pm
380/year? Check out webwiz it'l be much cheaper.

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


Posted By: dpyers
Date Posted: 18 April 2004 at 12:12am
380 a year is many times to much. Time to find another host. There are many good ones offering MS SQL for 20-30% of that cost.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: neotrix
Date Posted: 18 April 2004 at 6:08am
Exactly, but most probably, as u said you gota a small site, you wont need MS Sql, i dont know why i feel that MS Access DB will work for you :)

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..


Posted By: thustra
Date Posted: 18 April 2004 at 7:38am

dpyers - I presume compacting will cause no problems once it is uploaded again? Thanks for the tip.

Michael, I suppose Web Wiz is the obviously first port of call - certainly looks good to me, and a fair sight cheaper!



Posted By: dpyers
Date Posted: 18 April 2004 at 11:30am
Originally posted by thustra thustra wrote:

dpyers - I presume compacting will cause no problems once it is uploaded again? Thanks for the tip.

If possible on your host, I'd stop the web app before downloading it and restart when it's uploaded again.

When you compact and repair an access db off line and then upload it to the sebsite, be sure to delete any existing .lck file on the website. It tracks who's on the db and what they're doing - where. An existing one won't line up with the compacted db. If you delete it, it will be recreated when the compacted db is first accessed.



-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: WebWiz-Bruce
Date Posted: 18 April 2004 at 12:30pm
The access version of teh forum has a compact and repair feature built into the admin section so you shouldn't need to download the database.

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



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