Disadvantages of Access as a Web site database

The vast majority of Web sites online are now in the form of access+asp, because access is simple and easy to handle, and can meet most of the website's program requirements.
Access is a small database, and since it is small, there are some basic limitations, and in the following cases the database will be largely unbearable:
1. Database is too large, the general Access database reached around 50M performance will drop sharply!
2. Website visits frequently, often reach about 100 people online.
3. Too many records, the average number of records reached 100,000 or so when the performance will drop sharply!
(Note: The above 3 is only the result of our years of experience, and not only the absolute value, depending on the circumstances of different floating larger)
Access Forum (such as dynamic Network) is very easy to appear after the database problems, when your forum database in the 30M above, post 50,000, online is also around 100 people, your forum is basically in the processing of the database time, this time it is likely to appear the database unbearable situation.
The general symptom is all the pages involved in the database, suddenly run is surprisingly slow (execution time of more than 5 seconds or even a few 10 seconds), involving HTML and pure ASP operation of the page is normal, wait for a period of time (about 10 minutes or longer) and then suddenly recover. This time you can use the general ASP probe test, if the server operation time is normal, and your post volume is relatively large, is the database problem.
Workaround:
Because this is the limitations of access itself, there is no good way to solve the problem, in addition to reducing the amount of data and replacing large database forums, which is what is now often said about the forum crisis, and that large forums are not the reason for access. We recommend the following methods:
1. Temporary solution: Periodically delete redundant data, compress the database, limit the forum to pour water, or even limit the forum registration. If it is a dynamic network forum, you can use the forum's own table storage function, will have a better effect
2. A more long-term approach: the replacement of forums and databases, generally using the dynamic network of SQL commercial version +mssql solution, but this requires a relatively large investment. Because mssql2000 and access need more resources, just in memory, you can reach each online 1M above the degree, if your SQL forum 100 people online will eat server at least 150M of memory

Reprinted from: http://www.aspnetjia.com

Access is a disadvantage of a Web site database