Web Wiz Forums - Unknown file size

Print Page | Close Window

Unknown file size

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=2563
Printed Date: 31 March 2026 at 4:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Unknown file size

Posted By: Camisa
Subject: Unknown file size
Date Posted: 09 May 2003 at 2:41pm

Hello,

I'm running two forums on my personal webserver. On the first forum I have 2300 messages, and the MDB file takes 3mb. Now, on the 2nd forum (different location on the server) I have 10,000 messages, and the MDB file takes 100mb. How does it make sence?

And how can I removed messages any forum, (the 1st or the 2nd) and still the message-counter will show and same number of messages before I deleted?

I'm using the Access version.

Thanks,

Camisa

Replies:

Posted By: michael
Date Posted: 09 May 2003 at 2:58pm

Well it makes sence if the second forum (obviously) is more busy, Access does not automatically free up space on deletes and moves. So the file grows. You will see that once you run a compact of the database it will look better. The message counter can be resynced in the admin menu...

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

Posted By: Camisa
Date Posted: 09 May 2003 at 3:15pm

More busy by what? traffic?

How can I run a compact of the db?

Posted By: michael
Date Posted: 09 May 2003 at 5:00pm

You can either download the db and open it in access or there are scripts (check http://www.aspin.com/func/search?tree=aspin&qry=compact+access&cat= - aspin.com ) to run a compact via asp.

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

Posted By: WebWiz-Bruce
Date Posted: 10 May 2003 at 2:42am

Once you compact and repair the database, if you are using version 7 then I would recommened that you turn off the active users feature to keep the file size from growing so quickly.

-------------
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: Camisa
Date Posted: 10 May 2003 at 4:44am

Well, I'm sorry, but i'm kinda new at this DB/Access/SQL issues.

I tried downloading some on-line scripts, but all of them didn't work.
When i'm downloading the DB to my computer, and I open it by Access, what should I do than? I don't believe that deleting some users/messages will make the DB file less big.

Borg, i'm using the Access version 6.30.

Posted By: WebWiz-Bruce
Date Posted: 10 May 2003 at 6:43am

Download the database, open in access, and select 'compact and repair database' from the tools menu.

-------------
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: Camisa
Date Posted: 10 May 2003 at 9:28am

To download and to upload 100mb?

The problem DB is the big one. I have no problem with the 1st forum (3000 message, 3mb).

Posted By: WebWiz-Bruce
Date Posted: 10 May 2003 at 10:17am

If it only has 10,000 messages it should compact down to around 15Mb, which will also increase the speed of your forum.

Also I wouldn't be surprised, with a database of that size, that your web host may step in and ask you to remove it for using up to many server resorces as each time someone goes to your forum the server has to open a 100Mb file thuse slowing down the server for everyone using it, not just your site.

Posted By: Bluefrog
Date Posted: 10 May 2003 at 12:53pm

Just curious, if you're getting that much traffic and whatnot, wouldn't it make sense to move to a SQL Server DB instead? Access DBs are not meant for heavy use. Sounds like you're just using the wrong technology.