It may be a dumb question, but...

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
pvillaca Members Profile Find Members Posts Newbie Joined: 03 June 2004 Status: Offline Points: 34	Post Options Post Reply Quote pvillaca Report Post Thanks(0) Quote Reply Topic: It may be a dumb question, but... 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.