Web Wiz Forums - Benifits of SQL over Access ?

Print Page | Close Window

Benifits of SQL over Access ?

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=16459
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Benifits of SQL over Access ?

Posted By: Lynford
Subject: Benifits of SQL over Access ?
Date Posted: 07 September 2005 at 7:20am

Could someone explain the benifits of SQL over Access please (in idiots terms if possible

)

Would it reduce the bandwidth I use ? Increase speed ? etc etc.

Thanks

Replies:

Posted By: dj air
Date Posted: 07 September 2005 at 7:28am

the bandwidth wont change as its lcally done.

it will perform better once its been done , and the forum has had activity. as the indexs etc are used and make the forum run faster.

also it can cope with high activity, big forums also.

access is likly to corrupmore than SQL, and also access being a flat file it has the whole thing loaded into memory so can slow the whole server, where as SQL loads whats needed.

SQL also has stored procedures that increase the pertformance of the forum.

if you are looking at being an active, a few forum members at anyone time, have a big post count etc. then i woul suggest SQL version its better in the long run.