Web Wiz Support and Community Forums : It may be a dumb question, but... https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 14:51:39 +0000 Thu, 17 Jun 2004 04:46:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10894 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[It may be a dumb question, but... : The forum on this site is at over...]]> https://forums.webwiz.net/it-may-be-a-dumb-question-but_topic10894_post59835.html#59835 Author: WebWiz-Bruce
Subject: 10894
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 everytime  the database is connected to the entire file with all it'stables etc. need to be loaded into memory. MS SQL Server worksdifferently, it's a server so doesn't have the flat file system ofAccess. This means that when the database is connected to the entiredatabase does not need to be loaded into memory.

Another advantage of SQL Server is that the SQL Server is usuallylocated on a different server to the web server allowing each server todo a dedicated job.
]]> Thu, 17 Jun 2004 04:46:23 +0000 https://forums.webwiz.net/it-may-be-a-dumb-question-but_topic10894_post59835.html#59835 <![CDATA[It may be a dumb question, but... : Well, excluding the fact that...]]> https://forums.webwiz.net/it-may-be-a-dumb-question-but_topic10894_post59824.html#59824 Author: pvillaca
Subject: 10894
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?

]]> Wed, 16 Jun 2004 22:30:45 +0000 https://forums.webwiz.net/it-may-be-a-dumb-question-but_topic10894_post59824.html#59824