Web Wiz Forums - It may be a dumb question, but...

Print Page | Close Window

It may be a dumb question, but...

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=10894
Printed Date: 08 April 2026 at 2:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: It may be a dumb question, but...

Posted By: pvillaca
Subject: It may be a dumb question, but...
Date Posted: 16 June 2004 at 10:30pm

Well, excluding the fact that I lost all my data by not being able to import my Access db to the SQL server (although spending a full day trying to), I'm very very very pleased by the SQL version of the forum. It's fast, it has more features and it's working like a swiss clock.

The probably dumb question is: will the forum start getting slower after the number of messages and users grows a lot, just like the Access one? And why is the SQL version better regarding this problem?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 June 2004 at 4:46am

The forum on this site is at over 55,000 posts and not showing signs of slowing.

The reason for this is that MS Access is a flat file, this means every time the database is connected to the entire file with all it's tables etc. need to be loaded into memory. MS SQL Server works differently, it's a server so doesn't have the flat file system of Access. This means that when the database is connected to the entire database does not need to be loaded into memory.

Another advantage of SQL Server is that the SQL Server is usually located on a different server to the web server allowing each server to do a dedicated job.

-------------
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