Database 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=28355
Printed Date: 01 April 2026 at 8:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Database size
Posted By: freakyfred
Subject: Database size
Date Posted: 24 February 2010 at 8:26am
|
I have just got an email from my host stating that my access database is way to big at 30mb and that it neds to be compressed to below 5mb.. which is impossible as far s i can see. So what i was wandering is 30mb big for a access database to be running on a shared server?? Thanks |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 24 February 2010 at 10:24am
|
Yes most hosts have a limit of around 10MB. This is because web servers have disk systems for fast reading, databases need fast reading and writing If you have large Access databases on a web server it places strain on the server and slows down all the websites on that server. This is why SQL Server and mySQL are usually separate from the web server using a very different physical system to that of the web server. Your only option would be to delete most of the posts from your forum, or look to migrate to SQL Server. The Access version is only intended for very small forums with just a handful of users or for pre-production testing. ------------- 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: freakyfred
Date Posted: 24 February 2010 at 10:42am
|
Thanks bruce. I never intended for the forum to get so big. i will have to look into the migrate option i think. |
Posted By: dpyers
Date Posted: 24 February 2010 at 10:27pm
|
An access DB is really just one large file. Deleting information from
it doesn't actually remove space from the file, it just flags the space
as unusable.They always grow larger. The MS Access program has tools to compact and repair the data base - which basically re-writes and re-indexes it without all the unusable space. You can also compact and repair an access db with an asp script. - Google: compact access database with asp. This may or may not reduce the db size to acceptable limits for the server. It will improve end user response performance. Your ultimate solution is to migrate to MSSql. MySql is an option but complicates the migration process even more. EDIT: Whether you use the MS Access program, or an asp script, shut down the forum and back up the db first. Having users update the db while compacting is not good. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: aladin11
Date Posted: 25 February 2010 at 3:09am
WWF has built-in compact tool. Login to Admin control panel and look at "Compact Database" |
dpyers wrote:Posted By: freakyfred
Date Posted: 25 February 2010 at 10:36am
|
I have done all that but thanks guys. Even if i clear out alot of old posts it won't do much good for long. I need to convert. Can someone point me in the right direction for this please? thanks |
Posted By: WebWiz-Bruce
Date Posted: 25 February 2010 at 11:56am
|
Use the Microsoft Access database upsize wizard to upsize the database to SQL Server.
------------- 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: coffeeshopper
Date Posted: 26 February 2010 at 5:25pm
|
I have significant experience with MS Access database scalability. The only hard limits are 2GB in overall size...and the maximum number of concurrent connections. When too many people connect at once, the IIS connection/Access DB will crash. The only way to resolve this is to restart the IIS Application pool that the site is in. Ideally, you would want to use SQL Server instead of access. However, I have a heavily used web application with multiple concurrent users that is 1.55GB in size. It works just fine (except for some sporadic crashes due to too many connections). This database has been in production for 8 years. If your host is limiting you to a maximum of 5MB, I would definately recommend switching providers. That arbitrary limit is ridiculous. It would only make sense if the server were ridiculously overloaded with resource intensive sites. A 30MB Access file should NOT be a problem for them. On one of my servers, I'm running old school technology (Dual 2.8 Xeon) with RAID1 15 SCSI drives...and I can tell you that one database (at 30mb) will have a negligible affect on resource usage. That is absolutely the case...unless the applications are coded poorly. Then all bets are off. By putting sites into isolated application pools web hosts should be able to tell who is the culprit eating resources on their servers. That being said, I run my own servers and have RDP access to restart the site application pool in the very rare case that the connection crashes. |
Posted By: dpyers
Date Posted: 01 March 2010 at 7:29pm
|
A 30 Mb db is not a problem. Most shared hosting services run 500-2000 accounts per server. Each account can have multiple sites, and many will have Access db's. A good percentage of those will also use ODBC. Most shared hosts will put some size limitations on an Access db. -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: freakyfred
Date Posted: 07 March 2010 at 5:44pm
| Thanks. I think i will still move it over though. I have no clue as to what i am doing though. |
Posted By: Putz22
Date Posted: 08 March 2010 at 8:40pm
| It would be in your best interest to use the SQL Server as speeds will help out on you forum as well.. As Access is limited on Speeds.. a good suggestion would be to upgrade ASAP.. also for Security reasons too |
Posted By: freakyfred
Date Posted: 09 March 2010 at 9:50pm
The forum is shut down. The host was not too happy. |
Posted By: freakyfred
Date Posted: 31 July 2010 at 8:06pm
|
I was going to use Bullzip for this does anyone have any experience with this? do i just convert to a sql file and upload and connect? Thanks |