How Many Connection
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=24513
Printed Date: 06 April 2026 at 1:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How Many Connection
Posted By: Jeet Chowdhury
Subject: How Many Connection
Date Posted: 26 September 2007 at 12:44pm
| How many connection a access database can handle? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 26 September 2007 at 1:05pm
|
Microsoft claim 255, but when using an IIS web server with the JET database driver, you usually have a pool of around 20 shared with all websites that use the application pool the site is within. However, when it comes to forum software the number of connections is not the important facter when it comes to Access. Access is a desktop database system, and so is unable to cope with anything more than light use. When it comes to forum software the amount of read and writes placed on the database is quite high. This means that Access is often unable to cope with being the backend of a forum and often becomes corrupted if you have more than a handful of users. Access also places allot of strain on the web server, so many web hosts will have a limit of around 10MB to 20MB for a maximum size of an Access 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 |
Posted By: Jeet Chowdhury
Date Posted: 26 September 2007 at 3:57pm
oo, then ms sql is best right. or mysql? anyway how to backup sql server forum database in sql 2005. i'm planning to format my pc. . how to backup database to cd.
|
Posted By: Jeet Chowdhury
Date Posted: 26 September 2007 at 3:58pm
| is sql can handle unlimited connection? |
Posted By: WebWiz-Bruce
Date Posted: 26 September 2007 at 4:04pm
|
mySQL and SQL Server are both very good and can handle a high amount of active users and over a million posts. The simplest way to backup your SQL Server DB is to use the SQL Management Tools to create a backup. It's stored as a .bak file. ------------- 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 |