Database size getting too big?
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=19122
Printed Date: 12 April 2026 at 12:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Database size getting too big?
Posted By: ppkppk
Subject: Database size getting too big?
Date Posted: 03 April 2006 at 10:52am
|
Borg, a quick question, how big should one let the Access database get before there is any noticeable performance loss on the forum?
In the same vein if I were to increase the inbox size to say 50 messages and I have 4000 users, with about half of them using it to half capacity, do you think that this would cause a drain on the speed of the forum?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 03 April 2006 at 11:05am
|
Performance is more down to how fast your web server is and the amount of memory. However, the biggest limitation with Access is that it is a desktop flat file with a limitation of 20 concurrent connections. As a desktop file it is not really up to the job of being used as a forum database and so often becomes corrupted beyond repair. My advise is that unless you only have a handful of users, use a real DBMS like SQL Server or mySQL. Access is so bad, that I would rather not support it at all, but for some reason it is poplar with novice users who use windows web hosting. |
Posted By: megetron
Date Posted: 03 April 2006 at 2:34pm
|
I use access database, and I know for sure 50 concurrent users connect to it.
hou do u explain this?
|
Posted By: WebWiz-Bruce
Date Posted: 03 April 2006 at 2:58pm
|
If you are referring to web wiz forums having 50 users on at once on the access version then there are reasons for this. The database connection only remains open while the page is being processed by the server, so this may only be for less than a second, then the connection is dropped freeing it up for another user to use. Also web servers use connection pools, this can also help, and although access according to Microsoft can handle 255 concurrent connections, the connection pool in IIS is usually limited to 20 which is shared across the entire server. Still though at the end of the day, Access is a desktop file, which works just like storing data in a slightly more complex text file, so just is not up to the job of supporting a forum which continually updates and reads from this file. This often leads to the file becoming corrupted thus all the data for the forum is lost. If you are using a forum you should really look at using a Relational Database Management System (RDMS) like mySQL and SQL Server, both these are servers and are built to support large databases and many 1000's of users with continual updates. You really can not compare Access to SQL Server or mySQL, Access is just a simple desktop file built for small desktop applications, and not designed for the abuse an online forum will place on it. If you want to use Access then go ahead, but please don't come crying on here when you wake up one day to find that your Access database file has become corrupted and you have lost all the data. |
Posted By: Mikey
Date Posted: 03 April 2006 at 11:22pm
|
My opinion is that Access is only loved by new users because it's a 'File' just like 90% of things on there computer, When they create an access DB they can then go ahead and find it physicaly with ease. Also add to this that most Admin offices come complete with versions of office that include access. I only stopped using access versions of DB's (including webwiz foums) a year ago but i will never go back, the performance gain and load you can get from using MSSQL/MySQL etc is worthy of that little extra learning. I think webwiz forums being supported on MSSQL and MySQL gives the user plenty of choice, Ditch the dead weight that is access!  ------------- Handyman man? |
Posted By: WebWiz-Bruce
Date Posted: 04 April 2006 at 10:54am
|
I don't even have access any more as I now use Open Office 2 instead for the few documents I write a year as it is not only free but much faster than MS Office and compatble with MS Office documents, spreadsheets, etc. and can even work with Access databases. Also I don't want to pay over £100 for the standalone version of Access, that costs twice as much as the Developers version of SQL 2005!! If you look at mySQL and SQL Server 2005 Express they are both really good database servers and are free, which is much better than Access which is not only rubbish, but quite expensive. I'm hoping that most web hosts will start to see the light and start offering SQL Server 2005 Express as a cheap and better alternative to Access on their hosting plans. |
Posted By: wmeyers
Date Posted: 04 April 2006 at 4:42pm
|
I echo the above comments..its not so much when Access will fail, but why bother to use it to begin with.
Sql does come with additional overhead and requires maintenance to keep it running smoothly, but it can handle however large your forums grow.
|