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
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. |
thustra wrote: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 |