Web Wiz Forums - Acess Vs SQL

Print Page | Close Window

Acess Vs SQL

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

Topic: Acess Vs SQL

Posted By: mbd2
Subject: Acess Vs SQL
Date Posted: 08 April 2009 at 4:13pm

Over the past few months I been getting ready to convert wwf an SQL forum and been doing some simple testing. One thing I've noticed in the Access version is running faster? Should that be? I thought the SQL would be faster?

Has anybody else see this, or I'm I the lucky guy with a fast running Access db.

Access Stats are:
Our users have posted 30,330 Posts in 2,744 Topics in 52 Forum(s)

Then SQL is a back of the forum and is older so in theory has less data.

Just looking for some input and ideas if the change over is worth it?

Replies:

Posted By: 123Simples
Date Posted: 08 April 2009 at 4:45pm

Read this http://www.webwiz.net/webwizforums/webwizforums_downloads.asp" rel="nofollow - web wiz information

This is the slowest version of Web Wiz Forums. Access is a desktop database and is often unable to cope in a production environment leading to database corruption issues. This version should only be used for testing purposes

and then you may feel that upgrading is the better choice. However, and I always say this, make backups first

So many people run the upgrades without backing up things first, and then can end up pretty disappointed if it goes wrong

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: mbd2
Date Posted: 08 April 2009 at 5:11pm

That statement was not always there. When I started with version 5 (I think) it was just an option. Just recently did I notice the statement saying it should be used for testing only.

I always backup the db and the forum - just encase I have to revert back to the old format. Never really had to do that, but just a precaution I take just encase hard ware and software are not compatible.

-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video

Posted By: Lynford
Date Posted: 08 April 2009 at 5:24pm

I don't understand the technicalities of Access Vs SQL but I can share this with you:

I was running on Access, was having a lot of trouble with my Web Hosts, had to clean up the Database regularly by deleting posts, Forum was running very slowly, sometimes almost grinding to a standstill etc etc.

I now host with WebWiz (which may be a big difference as well) but we are running SQL. It is brilliant - Has been like this since early February and not one problem (touch wood)

I know Bruce & WebWiz can't recommend SQL over Access strongly enough.

Our users have posted 109,302 Posts in 6,986 Topics in 10 Forum(s)

Regularly have 200-300 Users online.

Hope this helps Big smile

Posted By: WebWiz-Bruce
Date Posted: 09 April 2009 at 10:02am

There are lots of issues with Access here are just a few:-

Access is a desktop database and was only made available for web use as Microsoft's SQL Server at the time was to expensive
Access has a limitation of 250 simultaneous connections shared with all websites and databases on the same server (this is theoretical in practice it is lower)
Access uses a flat file stored on the web server. The web server usually has a disk system that is intended for fast reads and not for databases. SQL Server is usually placed on a dedicated database server with a disk system that can handle fast sequential reads and writes
Access is fine for small databases under 10MB in web use or infrequently accessed databases, but often becomes corrupted when under load. Forums place a large load on the database so Access is not very good
Now Microsoft have the free SQL Server Express and the Web Edition they are phasing out support in their new OS's for Access. They have said they will not make a 64 bit JET driver
Access doesn't have the same server side paging as you would get from SQL Server

If you use the Access version of SQL Server it has been altered to place less load on the server due to limitations with Access. For example your forums will only display the first 1,000 topics, instead of all topics that you have with SQL Server with the server side paging.

We also see lots of issues with Access databases especially as forums get larger and busier and could only recommend that you use the Access version of Web Wiz Forums if you expect only a handful of visitors each day.

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